Skip to Content
avatar image
Former Member

Only sum the value from the group level

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Hi All, anyone can advise?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 07, 2017 at 01:58 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded