Currency in canvas calculation

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

2 Likes

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:

12%20PM%5B1%5D

4 Likes

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.

Concatenate("£",Left(123456,Length(123456)-3),",",Right(123456,3))

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: