How to display only positive value in the report ?

[geam1988]

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.

[Chanty4u]

try to add this in your expression

Sum({<Measur= {'>0'}>}Measure)

[sibin_jacob · Accepted solution]

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