Sum distinct rows

Question

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?&nbsp;

quickbasecoachd · Answer

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.

archiveuser · Answer

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.

quickbasecoachd · Answer

I'm sorry, but I am not understanding your specific question.

Forum Discussion

Sum distinct rows

Related Content

Distinct Dates

Percentages are Sums instead of Averages on the Total and Averages Rows

How to consolidate multiple rows into one

Modify multiple rows within the same group using Single Record ?

How can I create a report in Quickbase that aggregates multiple rows into a single line per record?