How calculate in Text Object

[Anonymous]

Hi guys,

How is possible to simplify the expression in text object:

='Overall NPS= ' &Round (Count({<[Overall experience]={'9-10'}>}[Overall experience])/count(TOTAL [Overall experience])-Count({<[Overall experience]={'0-6'}>}[Overall experience])/

count(TOTAL [Overall experience]),0.001)*100 &' %'

Please see also attached image

Thank you,

[Anonymous]

Maybe like it

='Overall NPS= ' &If((Round (Count({<[Overall experience]={'9-10'}>}[Overall experience])/count(TOTAL [Overall experience])-Count({<[Overall experience]={'0-6'}>}[Overall experience])/

count(TOTAL [Overall experience]),0.001)*100)<0,red(),blue()) &' %'

[Anonymous]

I don't know why my image lost

[Anonymous]

[MayilVahanan]

Hi

There is no other option to change the color of text box other than font tab in text box. You can increase the size, style, font and color in font tab..

PFA

Edit:

celambarasan already noticed it.. Thanx celambarasan

[CELAMBARASAN]

Quick question: Do you need the color for the Whole text or only for the value?

Means Overall NPS = 14% in blue or red or only 14% should be in blue or red?

[Anonymous]

I don't have name of this variable.

I calculate it in text box. It dependents of these results red or blue color.

I have chart, where I see %. but I don't know how use these % in Text Box

[Anonymous]

Only for value

[CELAMBARASAN]

Really thats not possible.