Loading

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

Fecha de publicación: Apr 2, 2026
Tarea
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?
 
Pasos
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
Número del artículo de conocimiento

001456636

Archivos adjuntos

calculate sum of multiple columns.tflx

10 KB

 
Cargando
Salesforce Help | Article