Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
Kumar
hi
try this
in Script:
if(Qty=0 0r isnull(Qty='-1'),'0','1') as Flag
in expression:
sum(Qty*Flag)
Sum(Value*Flag)
may it hepls you
thanks
rohit
flag expression is giving error
pls chk.
rgds
kumar
Hi,
try this..
if(Qty=0 0r isnull(Qty),'0','1') as Flag
Hope that is fine...
Hi,
try this..
if(Qty=0 0r isnull(Qty),'0','1') as Flag
Hope that is fine...
while reloading it is showing error.
kumar
The expression is correct only .. unless u have the Qty field in the table it will throw an error..
* if(Qty=0 0r isnull(Qty='-1'),'0','1') as Flag
while reloading expr is giving error
kumar
pls give me sugesstions
kumar