Null Value

[upaliwije]

Hi

I have pivot table in my QV document.

BRANCH	SUM(AMOUNT)
A	15,000
B	15,000
C	95,000
D	15,000
E	110,000
F.	15,000
G	124,000

In addition to the above there are some other Branches in my table where the value is null. I want to show all records in my pivot table and null vale as 0(zero) . Pls help me to get it done

Thanks

[tamilarasu]

Go to presentation tab and uncheck the Suppress - Zero values option.

[HirisH_V7]

Hi,

Can You post your sample App and Elaborate your requirement.

By the way ,

In your Expression at presentation For null values '-' instead of this keep '0'

Thanks,

Hirish

[#4]

Hi Upali,

Interestingly, I read a fascinating piece by another contributor (i.e. I can't claim credit for this!) recently which should hopefully be of use.

Hope it helps,

Regards,

Jason

Accumulations

[upaliwije]

still zero values do not appear

[tamilarasu]

Try the below expression,

If(SUM(AMOUNT)>0, SUM(AMOUNT),0)

[tamilarasu]

Just noticed, goto dimension tab Nd uncheck supress when value is null option for the branch dimension.

[avinashelite]

Try like this :

1.Set your null values as ZERO using the conditional statement or len function

2.In the Presentation tab un check the suppress Zero values option this should help you

[raghvendrasingh]

Hi,

Please find attached qvw, hope this will help.

Regards,

Raghvendra