AnsweredAssumed Answered

how can I get a Sum of a calculation per record

Question asked by ericjlindholm on Jun 26, 2017
Latest reply on Jun 27, 2017 by philmodjunk

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. 

Outcomes