Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below KPI , its not changing color as per the conditions specified in the code
Text object prop-> Background -> color> calculated
Conditions: Display RED if % > 70 (default)
Display Red if % > 20 (when anything else is selected on the block chart)
May be this
if(GetSelectedCount(BLDG)=0 and num(sum(ROOMSIZE)/2400
, '#.0%')>=0.70,GREEN(),
if(GetSelectedCount(BLDG)>=1 and num(sum(ROOMSIZE)/2400
, '#.0%')>=0.20,GREEN()))
May be this
if(GetSelectedCount(BLDG)=0 and num(sum(ROOMSIZE)/2400
, '#.0%')>=0.70,GREEN(),
if(GetSelectedCount(BLDG)>=1 and num(sum(ROOMSIZE)/2400
, '#.0%')>=0.20,GREEN()))
Nazneen, did Sunny's post an example get you what you needed? If so, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit for the help and let other Community Members know this did work for you. If you are still working on things, leave an update as to what you still need.
Regards,
Brett