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 have the Estimated fees column display a sum at the bottom, just like a numeric column can.

I understand that this can’t currently be done with the currency column, but there are apparently workarounds with Power Automate.

I don’t want to disappear down this rabbit hole/time vacuum at least for now, so I’m wondering if there is a simple workaround using a numeric column, with JSON custom formatting to display currency symbols and comma separation to turn number like this 11000 into this £11,000.00.

Is this too simplistic?

​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 have the Estimated fees column display a sum at the bottom, just like a numeric column can. I understand that this can’t currently be done with the currency column, but there are apparently workarounds with Power Automate. I don’t want to disappear down this rabbit hole/time vacuum at least for now, so I’m wondering if there is a simple workaround using a numeric column, with JSON custom formatting to display currency symbols and comma separation to turn number like this 11000 into this £11,000.00. Is this too simplistic?  Read More

​