Aggregates
In my app, I have a view that shows a list of related things with an aggregate to SUM the Quantity column of those fields.
Here is my issue, My view only shows 5 in-lines rows and now my aggregate only does a SUM on those 5 instead of all related rows.
I know the obvious fix is to increase my in-line rows to 10 or 100. Not an option in this instance. I need it kept at 5.
Is there a work around or another option?
Why not just have the sum as a virtual column on the parent?
Like @Grant_Stead says, put in a virtual column to do the calculation.
SUM([Related Quantity Column])
The most effective way to calculate the sum from related records is SUM(SELECT([ListOfRelatedRecords][QuantityColumn],TRUE))
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |