Only sum the value from the group level

[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.

[Former Member]

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.

[Former Member]

Hi All, anyone can advise?

Thanks