Loading

How To Calculate The Aggregation Of Multiple Columns Without Creating A Calculation Field

Publiceringsdatum: Apr 2, 2026
Uppgift
When creating a new column that shows the sum of multiple columns by a calculation field, all the columns need to be added in the calculation field. Is there a better way to do this?
 
Steg
1. Connect to data source "datasource.xlsx".
2. Drag table to Flow Pane
3. Add a step Pivot
4. Drag the columns num0 ~ num10 to Pivot Fields
5. Add a step Aggregate 
6. Add other columns (No, Category, Name) in Grouped Fields
7. Add num to Aggregated Fields
8. Add a step Clean Step, to check the results
9. Add an output
Knowledge-artikelnummer

001456636

Bilagor

calculate sum of multiple columns.tflx

10 KB

 
Laddar
Salesforce Help | Article