Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i have an issue whereby my visual indicator is including the totals row as well.
this example shows the Total being 4993 which is smaller that Plan/Day which is 8930 . Hence it should be red.
However it is pointing towards the single number 893 instead of the total 8930 and showing green.
is there any way to get the visual indicator not to show for totals, or make it red in this instance?
Best Brad
Hi Brad
I guess this is related to the formula you used in visual cues.
You might either modify it or use in background properties of the expression
if (dimensionality=0, if (A < B, red(), green())
means if is total line, do the test
Or if you prefer to remove color, just use white() everytime
best regards
chris
Hi Christian!
thanks for the advise.
i tried the logic however could not get it to work,
have attached a copy of my document, perhaps you could lend a helping hand?
Best,
Brad
Hej Bradley
Den er dine qvw.
I made it simple, using expression background colour.
I hope it fits you
Best regards
Chris