Calculating New Columns - SUM Function?

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! :slight_smile: