Solved: Format Rule for blank rows in different table - Page 2

Doors · 02-04-2020 05:53 AM

Hi All,

I would like to apply a format rule to the table “Classes”.

However the rule needs to inspect a different table (Anglefish) to see if there are any blank rows in the Column “Dinner”.

If there are blank rows I need the format rule to be enforced.

Could I please have a hand with the expression?

Thanks.

Doors

Ta for that, unfortunately an error in the expression somewhere:

Expression ‘COUNT(SELECT(Anglefish[KeyColumn],ISBLANK([Dinner])>0’ could not be parsed due to exception: Number of opened and closed parentheses does not match.

View solution in original post