Color of text not changing in pivot table

[ashis]

Hi,

I have a pivot table and it has one calculated dimension. The expression is as follow:

=num(aggr(sum({<XXX=,Date={'$(vDate)'}>}YYYY),AAA, BBB,CCC,DDD),'#,##0;-#,##0')

I want negative value in red so in the text color of calculated dimension I used the following expression :

=if(sum({<xxx=,Date={'$(vDate)'}>}TOTAL<AAA, BBB,CCC,DDD>YYYY)<0,rgb(255,0,0),Black())

The above expression is working fine however I notice it is not working for few days only.

Please share your thought what could be the issue or should I need to change the code.

[sushil353]

You can use alt() function to replace the null values.

Try: Alt(yourexpression,0)

HTH

Sushil

[ashis]

Hi Sushil,

Yes I already used Alt function in my expression , but did not work.

I guess we need to do it from database level.