Discussions

Expand all | Collapse all

Sum distinct rows

  • 1.  Sum distinct rows

    Posted 08-30-2018 21:01
    Hi there, it is me again.
    I created a related table that saves all issues that one ID can have in time, so this table generate a row different row, every time that a issue is informed. After that, i created a chart that shows me the sum of the price for every issue, but does not discrimina if the id is unique or not and leaves the chart with the double or triple of the real sum. How can i make that show me only the unique IDs? 


  • 2.  RE: Sum distinct rows

    Posted 08-30-2018 21:34
    It sounds like the price is a lookup from the ID record down to the issue records.

    If that is the case, then simply make your report or chart based in the Average Price and not in the Sum of the Price. Every Price lookup for an Issue is identical, so the average will just be an average of identical numbers and not double or triple count.


  • 3.  RE: Sum distinct rows

    Posted 09-03-2018 20:52
    We need something like this, the final resault is to create the chart that I told you on the fist place, butas you can see, the records could be repeated but with other MC.



  • 4.  RE: Sum distinct rows

    Posted 09-03-2018 20:56
    I'm sorry, but I am not understanding your specific question.