Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In Pivot chart, I have dimension (location,item) , expressions(quantity,value). Here, I have value but quantity is zero for some items. I need to cut this value when quantity is zero. after that sub total(show partial columns - by checked) is having the total value(including value of zero quantity). So please give me suggestions.
my expression for Qunatity is == sum(PQTY-MQTY)
my expression for Value is == sum(PSTOCKVALUE-MSTOCKVALUE)
Expecting your reply.
Location Item Qty Value
Stores Apple 5 10
orange 12 15
banana 0 3
grapes 0 2
pineapple 2 6
total 19 36
i need
total 19 31
Thanks
Kumar
this is correct. but for my case, i need to put sum() inside IF cndtion that "PSTOCKVALUE-MSTOCKVALUE".
so tat inside values will be correct.
Kumar
pls find attachmnt
Hi,
It is correct in chart Stock 3 it is correct.
Rgds
Anand
but dispayed records total is not equal to sub total.
pls chk.
Kumar
hi
use flag in your edit script
thanks
rohit
while reloading it is showing error. i checked in expression it is showing error for isnull().
pls give me sugesstions
kumar