Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
try with aggregation, if(sum(NPM_TOTAL_SALES)<= 0,'red','green')
Bye
Use it like : IF(NPM_TOTAL_SALES<= 0,red(),green()) or IF(NPM_TOTAL_SALES<= 0,rgb(255,0,0),rgb(0,255,0))
IF(NPM_TOTAL_SALES<= 0,red(),green())
Use the above.
Besides why not trying.
Keep in mind the below option works only with expressions:
hi,
try with aggregation, if(sum(NPM_TOTAL_SALES)<= 0,'red','green')
Bye
Hi
Thanks. However it does not work.
can you send us screenshot of your graphice and expression please?
try to add expression with if(NPM_TOTAL_SALES<= 0,'KO','OK') in the graphic and look if it works fine.
Thanks!
Now it works 🙂