Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart with two columns of data both using the same Fieldname but existing in different states.
The expressions are:
=Sum({[Chart 1]} Fieldname)
=Sum({[Chart 2]} Fieldname)
I am trying to write a expression under the background color box that would compare the number in both columns and highlight them in yellow if the are different. What I have written is below. The expression is OK but it is not showing up as yellow where it is different. Any idea on what is wrong in the expression?
=If(Aggr((Sum({[Chart 1]} [Addressable Spend])) <> (Sum({[Chart 2]} [Addressable Spend])), yellow())
Why not just this:
If(Sum({[Chart 1]} Fieldname) <> Sum({[Chart 2]} Fieldname), Yellow())
Why not just this:
If(Sum({[Chart 1]} Fieldname) <> Sum({[Chart 2]} Fieldname), Yellow())
Probably
if(Coumn(1)<>Column(2),Yellow())
That worked perfectly. Thanks for your help!
No problem at all... Happy to help