Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Text object that shows the Operating % (vOpExPercent) ) vs the Target (OP_TGT) based on the associated field called AU_IT_TOWER.
This expression works perfectly for each individual tower:
$(vOpExPercent) & '% vs ' & OP_TGT
The problem I have is that I need to show a target if either all 7 Towers are selected or if none of the Towers are selected. Each year also has a different target.
I tried to accomplish this using the following expression but it doesn't work:
$(vOpExPercent) & '% vs ' & if(GetSelectedCount(AU_IT_TOWER=7) or GetSelectedCount(AU_IT_TOWER=0) and (FISCAL_YEAR='FY15'),'xx%', (OP_TGT))
Please Help! I'm stuck.
TIA,
Cassandra
Seems to me that your comparison is wrong
if(GetSelectedCount(AU_IT_TOWER) = 7 or GetSelectedCount(AU_IT_TOWER) = 0 And ....
Seems to me that your comparison is wrong
if(GetSelectedCount(AU_IT_TOWER) = 7 or GetSelectedCount(AU_IT_TOWER) = 0 And ....
Duh. Thanks Josh!
Hi Cassandra
Your =7 needs to be outside the bracket GetSelectedCount(AU_IT_TOWER)=7