visual indicator ignore on totals

[#1]

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

[#2]

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

[#3]

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

[#4]

Hej Bradley

Den er dine qvw.

I made it simple, using expression background colour.

I hope it fits you

Best regards

Chris