Having Difficulty in showing difftotal in pivot/straight table

[#1]

Dear All,

I am creating a stock table for items

In that i am having column as Item Receipt (Qty) Issue(Qty) Diff(Qty)

Selection Parameters as Item/Year/Month/Day

Now for some items there may be null values for Receipt(Qty) or Issue(Qty)

what i wanted to show in Diff column is Receipt-Issue

Since some values are null it is not showing any value in Diff Column for those items

So i replaced null values with number 0

but even then also it is not showing any value in difference column

Note: For receipt(Qty) i am using expression only(Receipt Qty) and for issue qty am using only(Issue Qty)

for Diff i am using only(Receipt-Issue)

Can you guys please help me..

[#2]

Dear Raj,

Use the following expression

For receipt Qty :- if(len(only(Receipt Qty))>0,only(Receipt Qty),0)

For issue Qty :- if(len(only(Issue Qty))>0,only(Issue Qty),0)

For Diff :- if(len(only(Receipt Qty))>0,only(Receipt Qty),0) - if(len(only(Issue Qty))>0,only(Issue Qty),0)

This should work.

Thanks & Best Regards,

Kuldeep Tak