Skip to Content
0
Former Member
Jul 23, 2013 at 11:12 AM

How to eliminate records based on sum(meansure) =0

15 Views

Hi,

Please let me know if you have any solutions for the below issue:

I have a Report with the below format:

Date Mob no IMEI no Amount Unit

08/15/2013 1234 23456 700 1

08/16/2013 1234 23456 -700 -1

09/15/2013 1234 76543 700 1

09/16/2013 4567 88888 800 1

12/30/2013 4567 88888 -900 -1

12/30/2013 5678 98765 6000 0

Basically, the original report should be modified to get the below output.

If the Mob no and IMEI no is same and if the amount is 0 then the entire row should not be displayed.

This report should be modified to the below format:

Date Mob no IMEI no Amount Unit

09/15/2013 1234 76543 700 1

09/16/2013 4567 88888 800 1

12/30/2013 4567 88888 -900 -1

12/30/2013 5678 98765 6000 0

Can you please let me know any solutions for the below issue. I am using BO WebI XI3.1

Thanks