Sum distinct rows

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
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? 
Photo of Braulio Chavez

Braulio Chavez

  • 150 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
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.
Photo of Braulio Chavez

Braulio Chavez

  • 150 Points 100 badge 2x thumb
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.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
I'm sorry, but I am not understanding your specific question.