Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I have this value as master item "Diff" and use it for a KPI chart:
Sum(actual) - Sum(budget)
To get red colour I defined the KPI measure as follows:
if(([Diff])<0, red(), green())
But this is ignored and the value thereafter also is wrong.
Any ideas?
That's... not how KPI measures work, I believe.
Your measure should be Diff. Color should be set using Appearance / Color / Conditional Colors with a single limit set at 0.