How to make the text colour independent of the filter list?

[Anonymous]

I have to make the text colour of the expression independent of the selections present in the filters of Business Area, Application and PERIOD NAME.

When the value of the expression is less than the Threshold font should be red, when its above the threshold it should be green and when its between 0.994 and Threshold it should be amber.

When I select values in the filter box for Application the font colour changes to black and does not maintain the desired colour range.

My expression written in the Text format is  -

if( (1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON)) )>=[Theshold numeric], rgb(0,128,0),
if((1- (sum(CUSTOMER_IMPACT_MINS)/sum(MINS_IN_MON)))>=0.995 and (1- (sum(CUSTOMER_IMPACT_MINS)/sum(MINS_IN_MON)))<[Theshold numeric], rgb(255,92,15),
if((1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON)) )<=0.9949,rgb(255,0,0))))

Can somebody please help with the expression to ensure the colour of the font doesnt change as per the filter selection?

[Anil_Babu_Samineni]

Perhaps this

if( (1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON)) ) >= [Theshold numeric], rgb(0,128,0),
if((1- (sum(CUSTOMER_IMPACT_MINS)/sum(MINS_IN_MON)))>=0.995 and <[Theshold numeric], rgb(255,92,15),
if((1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON)) )<=0.9949,rgb(255,0,0))))

[Anonymous]

This doesnt seem to work

[Anil_Babu_Samineni]

Can you post application?

OR Try This

if( (1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON)) ) >= [Theshold numeric], rgb(0,128,0),
if((1- (sum(CUSTOMER_IMPACT_MINS)/sum(MINS_IN_MON)))>= 0.995 < [Theshold numeric], rgb(255,92,15),
if((1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON)) )<=0.9949,rgb(255,0,0))))

[agomes1971]

Hi,

please post a application sample it's easier to analyze.

Thanks

André Gomes

[Anonymous]

Attached is the application.

[Anonymous]

See below.. Attached the file

[sunny_talwar · Accepted solution]

Try this:

=if( (1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON)) )>=Only({<PERIOD_NAME=,[Business Area]=,Application=>}[Theshold numeric]), rgb(0,128,0),

if((1- (sum(CUSTOMER_IMPACT_MINS)/sum(MINS_IN_MON)))>=0.995 and (1- (sum(CUSTOMER_IMPACT_MINS)/sum(MINS_IN_MON)))<Only({<PERIOD_NAME=,[Business Area]=,Application=>}[Theshold numeric]), rgb(255,92,15),

if((1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON)) )<=0.9949,rgb(255,0,0))))

[Anonymous]

Thanks..it worked

[Anonymous]

Can you please explain what 'Only' function did that I was missing out in my script??