I was wondering if anyone has tried the PowerFX Sum function with Datatables to sum a column in the table.
Without enabling PowerFX I go through the 'regular' looping method to create a running total or sum, but hoped that with PowerFX we would be able to reference the first column and just use SUM.
To read value from datatable use =ReadCell() function.
Example: My table
So I will sum column1 value so like so: 3 +5 +7 +8 = 23
First Set variable that you will sum the values to and set it to 0.
Then use For each loop that takes the data table and in the loop Set variable that uses the Sum (=Sum()) to read int value (Int()) CurrentItem column1 (ReadCell(CurrentItem, 1)) and the sum value to sum to itself.
Or break it into two set variables for readability:
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Screenshot 2025-0...
Share
Report
All responses (
Answers (
4,204
