Hi,
I need help with how can we convert the number 32354645 to 32,354,645.00 or -922692.31 to -922,692.31.
Can anyone help with logic.
Thanks!
Discussion posts and replies are publicly visible
The text() function is your friend.
For this use case, you may also consider "fixed()" --
Additionally if you expand the "Text Functions" list (in particular) here at the All Functions page, you'll find a lot of neat tools you can use for basic transforms like this and others.
docs.appian.com/.../Appian_Functions.html
Hello shobhits6437 You can use fixed( number, decimals, no_commas ) function to achieve this.