Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am using expression to define value of plan in KPI object. I am using IF statement: =max(if ([AREA]='name', Value, if([AREA]='name 2', '30'))). 30 I would like to display if nothing is selected (no area is selected) however cannot make it working. Can anyone help with this issue?
Hi Anastasiia,
I don't understand truly, but I think the getselectedcount function can help you
=if(getselectedcount(AREA)=0,'What you want to show when nothing is selected',max(if ([AREA]='name', Value, if([AREA]='name 2', '30'))))
or similar logic.
G.