i have a report, it generates a dynamic table, meaning the # of rows can change once its refreshed... I am trying to add conditional formatting, comparing 2 numbers in 2 different Tables.
i cannot select the cell because the location will change on refresh. I tried using Area_Sales[[#Totals],[% PAPER]] > Territory_Sales[[#Totals],[% PAPER]] but this doesnt work
can i use this type of reference? am I doing something wrong? if I place this is a cell is returns TRUE... solution?
i cannot select the cell because the location will change on refresh. I tried using Area_Sales[[#Totals],[% PAPER]] > Territory_Sales[[#Totals],[% PAPER]] but this doesnt work
can i use this type of reference? am I doing something wrong? if I place this is a cell is returns TRUE... solution?