I have a fairly simple report table grouped by Customer with a single row rule defined to format font and background when the value of "Status" equals "Total O/S" which would result in the last row of each table being formatted. I have done this many, many time before, but for some reason the rule is not being applied correctly. Sometimes it misses rows that meet the criteria (see customer #123 & #76) and sometimes it applies the formatting to rows that do not meet the criteria (see Customer #75).
Has anyone ever encountered this before?
Here is the rule config
Definitely strange.. maybe try putting that same condition in the formula option and see if that works? Also a longshot, but maybe try toggling AMP off if you have it on and seeing if you get a different result.
@MrSmartyPants Certainly strange. You dont happen to have any Column rule, right?