Aggregates In my app, I have a view that sho...

[Aaron_Moolb]

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?

[Grant_Stead]

Why not just have the sum as a virtual column on the parent?

[Jesse_Prud_Homm]

Like @Grant_Stead says, put in a virtual column to do the calculation.

SUM([Related Quantity Column])

[Aleksi_Alkio]

The most effective way to calculate the sum from related records is SUM(SELECT([ListOfRelatedRecords][QuantityColumn],TRUE))