Skip to Content
0

Only sum the value from the group level

Aug 01, 2017 at 02:50 AM

25

avatar image
Former Member

Hi All,

I have a report with 2 tables. ER101_SO and PO101_PO.

ER101_SO is link to PO101. One line in Er101_SO can link to more than 1 line in PO101_PO.

In Er101_So, there are one first which is "Charges".

In my report, I have one group which is SO_Number.

When I sum up the Charges, I notice some of the Er101_SO duplicated because of the 1 is to many issue.

For Example:

SO 12345 Charges $300 have 2 POs. then my charges will be double.

I only want to add once for each So_charges.

How can I do that?

Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Aug 07, 2017 at 01:51 AM
0

Hi All, anyone can advise?

Thanks

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 07, 2017 at 01:58 AM
0

HI All,

I tried another way. I placed my ER101_SO to detail and then select "Suppress if duplicated". With this in the detail, the duplicated value will not show but when I Sum(Er101_SO), the duplicated value will still sum up.

Share
10 |10000 characters needed characters left characters exceeded