Skip to main content

How can I calculate the sum of a repeating field, and display it on a form? Also how can I reference this value in a workflow? For example if the sum is greater than $25,000, send an email for approval to a manager.

I solved my own question. The solution was to use the Calculated Value control, and set the sum function to the name of the field I want calculated. For the reference, I created a new list field, and set the Calculated Value control to use this.

Message was edited by: jason white

Well done Jason, and you are correct about the resolution. Please mark your own answer correct or add a second response with the answer to mark it correct to benefit others with the same question.

Thanks!


Unfortunately this seems to break if a row is deleted, or a value updated.


Reply