my apologies in advance for how bad I am at communicating my ideas.
is there a clean way way to get get the sum of a calculation per record without creating a field with that calculation in that table?
current example requires a field that contains the result of the calculation - sum ( child::qtyXpricePer)
desired example that i know does not work- Sum ( child::qty * child::pricePer )
I could do something like loop through the child records, calculate a variable and sum that but I am hoping for something cleaner then that.