Expression if nothing is selected

[Anonymous]

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?

[undergrinder]

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.