Skip to Content
0
Jul 19, 2016 at 07:58 AM

display if more than one value - how to achieve in WEBI

1446 Views

Hi guys,

Just wanted to ask how we can achieve in WEBI the RESULT "display if more than one value" in query designer?

I already read different threads but still can't make it work..

https://scn.sap.com/thread/3223903

http://scn.sap.com/thread/2030436


So the upper part of the screenshot above is the result of our current webi report..

Then the lower part is the result of what I have done so far to achieve this requirement..

The image on the right SHOULD BE the output..

My question is how can I remove the BLANK rows? I already tried the settings of the table below but still no luck..


These are the formulas I have used in the RESULT (yellow background) part..

=If Sum([CALDAY])<2 Then "" Else "Result"
=If Sum([CALDAY])<2 Then "" Else Sum([CALDAY])
=If Sum([CALDAY])<2 Then "" Else Sum([Bill.qty in SKU])
=If Sum([CALDAY])<2 Then "" Else Sum([Quantity in Liters])
=If Sum([CALDAY])<2 Then "" Else Sum([Amount])
=If Sum([CALDAY])<2 Then "" Else Sum([Peso/Liter])

Thank you..

Loed

Attachments

delete.jpg (338.7 kB)
delete2.jpg (83.9 kB)