cjwilson1009
Design Dabbler

Show Integer Variable with Commas and Decimals

I have a form variable in Nintex Forms O365. The variable calculates the total in my repeating sections. How do I display this number as currency, with commas and decimals? The formula works and does calculate the total correctly, I just don't like the way it's displayed.

I've added a screen capture of my variable. Please help! Thank you 🙂 

 

AccrualVariable.png

 

 

0 Kudos
Reply
2 Replies
ghaiashish
Process Pupil

Re: Show Integer Variable with Commas and Decimals

Hi cjwilson1009

 

Use currency form control on the form and use desired no of decimal places

ghaiashish_1-1617057143291.png

Use rule that is always returns true to get the variable value in the control(you can make control read only)

ghaiashish_2-1617057235361.png

Your variable type should be a decimal and not Integer

ghaiashish_3-1617057295784.png

This is how you see this on the form with 2 decimals

ghaiashish_4-1617057393709.png

 

Hope this helps 

regards,
Ashish

 

0 Kudos
Reply
EuanGamble
Nintex Employee
Nintex Employee

Re: Show Integer Variable with Commas and Decimals

Hi @cjwilson1009,

 

@ghaiashish is correct. The easiest way would be to populate a currency control. The other option would be to use a label with some formatting using variables. I have created a video showing some of the options available.

 

 

Hope that helps.

 

Cheers,
Euan

Reply