Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Expressions
Order Quantity = Sum(EKPO.MENGE)
Arrived Quantity = sum({<EKBE.BWART = {'101'}>}EKBE.MENGE)-sum({< EKBE.BWART = {'102'} >} EKBE.MENGE)
Difference Quantity = $(vdiffmenge)
Variable
vWE-Menge = sum({<EKBE.BWART = {'101'}>}EKBE.MENGE)-sum({< EKBE.BWART = {'102'} >} EKBE.MENGE)
vdiffmenge = Sum (EKPO.MENGE) - ($(vWE-Menge) )
I have this report
in the report i do not want to show any negative quantity and (0) quantity. i just want to show only positive value.
i want to show like this,
Please do not hesitate to contact me if you have any question.
Write the expression like below
Order Quantity
if($(vdiffmenge)>0,Sum(EKPO.MENGE),0)
Arrived Quantity
if($(vdiffmenge)>0,$(vWE-Menge) ,0)
Difference Quantity
if($(vdiffmenge)>0,$(vdiffmenge) ,0)
Then go to Presentation tab -> suppress zero values
Thanks,
Sibin
try to add this in your expression
Sum({<Measur= {'>0'}>}Measure)
Write the expression like below
Order Quantity
if($(vdiffmenge)>0,Sum(EKPO.MENGE),0)
Arrived Quantity
if($(vdiffmenge)>0,$(vWE-Menge) ,0)
Difference Quantity
if($(vdiffmenge)>0,$(vdiffmenge) ,0)
Then go to Presentation tab -> suppress zero values
Thanks,
Sibin