IF(GetSelectedCount...) in a Text Box

[cbaqir]

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

[jduenyas · Accepted solution]

Seems to me that your comparison is wrong

if(GetSelectedCount(AU_IT_TOWER) = 7 or GetSelectedCount(AU_IT_TOWER) = 0 And ....

[cbaqir]

Duh. Thanks Josh!

[Anonymous]

Hi Cassandra

Your =7 needs to be outside the bracket GetSelectedCount(AU_IT_TOWER)=7