Is there a SUM function under the Calculating New Columns action? I just need to sum a field but I get and error message that says "Unknown function SUM."
Hi Jaden, and welcome to the Community!
The SUM function is an aggregate function (over a column). To calculate aggregates in EasyMorph, use the "Aggregate" action. If you need the sum to be present as a column value, use the "Total/subtotals" action - it adds an aggregate as a column so that it's available in row-level calculations.
Expressions used in the "Calculate new column(s)" action only perform row-level calculations.
Ok that works great. Thank you!
You're welcome!