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:
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 
3 Likes