Pivot table Expression

[#1]

Hi All,

I am facing issue with null values. if the value is null it is displaying as 0.

This is the expression

=Sum({<WAVE = {"WAVE1"}>} DEALER_RECOMMENDATION_VALUE_CURRENT_WAVE)  *0.2*100)

Please help.

[maxgro]

maybe you can use the nullcount to check for null, example

if(NullCount(exp)>0, '???',  sum(exp))

[jonathandienst]

If displaying 0 is not correct, what would you like to see if the underlying field is null?

[#4]

Hi,

i need to display null as empty. (Wave3, Wave4, Wave5 columns are empty)

This is how i display in SSRS report. I am trying to replicate the same in QV report.

Also i need to display the average. please help.

Thanks

[Anonymous · Accepted solution]

= if ( Sum({<WAVE = {"WAVE1"}>} DEALER_RECOMMENDATION_VALUE_CURRENT_WAVE) > 0 ,

     Sum({<WAVE = {"WAVE1"}>} DEALER_RECOMMENDATION_VALUE_CURRENT_WAVE)  *0.2*100) ,

     null() )

[#6]

Thank you Bill.