Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am using "Simple KPI Extension" object. In that i am calculating a measure named "Diff".Pls refer attached image "Difference.png"
I have used a color code expression to show Diff value in red if <0 and in Green if >0. Pls refer the attached image named as "Color Code.png". But my negative values are being shown in Green only and not in red. My expression is correct but no idea why it is behaving so. Can anyone help on this?
Thanks,
Nikhil Garg
Hi,
expression looks correct.
can you share the app .
Hi,
This can sometimes happen because of placing of brackets, can you check with the below code.
if(((Sum(your exp)/10000)-(Sum(your exp)/10000))>0,Green(),Red())
Regards,
Saniya.
Share sample app..
Else try to do it first in table and then add it to chart
Hey ,
I tried your way but also didnt worked. Pls find below expression:
if(((Sum({<[Transaction Type] = {'Sales'}, Year = {$(vCurYear)}, MonthNumber = {"<=$(=vCurMonth)"}>}Amount)/10000)
-
(Sum({<[Transaction Type] = {'Sales'}, Year = {$(vPrevYear)}, MonthNumber = {"<=$(=vCurMonth)"}>}Amount)/10000))> 0,Green(),Red())
Hey,
and it works for staright table but not for Simple KPI ObjectI tried the same in staright table as well. Used same expression for background color but not for Simple KPI Object. Pls find attached snapshot.
In which chart you are trying this expression?
I ahve taken the extension "Simple KPI Object" where color code not working.
Then i tried to implement the same color code expression(as background expression) in "Straight Table" and it works fine. It is not working fine in Simple KPI Object Extension
try using hex colors in expression
Well, i can try dat also but i guess when rgb() for green working then it should work for red as well.
Wat Say?