Forum Discussion
Solved
Sum of calculated Currency column without Power Automate
I have a Microsoft List for our projects with a calculated currency column calculating estimated fee income based on a percentage (from a separate column) of the project value column. I want to h...
- You can't sum a calculated column. You'd need a flow in Power Automate and have it update just the first item in the Sum column with the result.
Thanks Rob - it's a calculated column though with this formula: =[Budget]*[Fee percentage]
I can't see how to to use number format columns with calculated values and the column totals.
I can have calculated columns with number format and totals, calculated columns with currency, and number format columns with currency and totals, but apparently not calculated columns with totals.
I did Google this, but answers seemed to be all dating back a couple of years. I was hoping there was a fix with more recent updates.
You can't sum a calculated column. You'd need a flow in Power Automate and have it update just the first item in the Sum column with the result.
- Thanks - I did see this but hoped things had moved on.