Set analysis

[Zaga_69]

Hi guys,

Just a simple question. I am trying to set the text color expression in a pivot table by doing:

IF(NPM_TOTAL_SALES<= 0,'red','green')

However, it does not work. The negative number are still in green.

Any idea?

Many Thanks,

Edi

[anushree1]

Use it like : IF(NPM_TOTAL_SALES<= 0,red(),green()) or IF(NPM_TOTAL_SALES<= 0,rgb(255,0,0),rgb(0,255,0))

[MindaugasBacius]

IF(NPM_TOTAL_SALES<= 0,red(),green())

Use the above.

Besides why not trying.

Keep in mind the below option works only with expressions:

[juliensaintmaxent3113 · Accepted solution]

hi,

try with aggregation, if(sum(NPM_TOTAL_SALES)<= 0,'red','green')

Bye

[Zaga_69]

Hi

Thanks. However it does not work. 

[juliensaintmaxent3113]

can you send us screenshot of your graphice and expression please?

[juliensaintmaxent3113]

try to add expression with if(NPM_TOTAL_SALES<= 0,'KO','OK') in the graphic and look if it works fine.

[Zaga_69]

Thanks!

Now it works 🙂