Currency in canvas calculation

How can i convert a calculation to a currency format in a plain canvas??


We currently do not have canvas currency formatting - so maybe ConCat the result with a currency symbol?

One piece of (not very well documented) syntax:



Great! Thank you very much.
Any way to add a thousandth comma separator?

I couldn’t do it with the Format function, since the comma needs a string.
So back to the old Concatenate.


This obviously works with exactly 4 to 6 digits. You would have to extend it and add a SwitchIf function to check the length first.
Then have separate cases for the length of the number: up to 3, 4 to 6, 7 to 9, etc.

Hope this helps!

1 Like

+1. Having more currency options (or the ability to add custom currencies) is very crucial.

Format & Concatenate work only for display columns but not the ones that we want to enter the amount into.

Also the sum function does not work with FORMAT or CONCATENATE.

Pleeassse, I hope this basic feature can be added soon, because it’s making things really difficult :slightly_frowning_face::slightly_frowning_face::slightly_frowning_face: