Not adding the commas to the numbers when generating a document

I have a simple document generating workflow that is pulling from a SharePoint list which contains numbers with commas. When i generate the document, these numbers are not including the commas in the numbers. For example:

$30,000 (How it looks in SharePoint)
$30000 (How it looks when generating the document using the variables)

Anyone know how I can include the commas exactly how it shows in SharePoint? Hopefully I am making sense.

Thank you!

Page 1 / 1

Hi @tonyrgreco

Welcome to the community.
If you use a Format Number to string action to format the currency before adding it to the document, does that help?
https://help.nintex.com/en-US/nwc/Content/Designer/Actions/FormatNumbertoString.htm

@SimonMuntz Thank you bud. I am going to try this tomorrow. I will post my findings. Appreciate the help!

@SimonMuntz That worked. Thank you sir.

@SimonMuntz I do have another question. Is there a way to remove the decimals after the number?

I am getting:

$30,000.00
and I would like it to read:

$30,000

Thank you

Hi @tonyrgreco,

After you have converted the value, use a regular expression action to EXTRACT the whole number.
The pattern to use is ^s\d,]*

@SimonMuntz

Thank you. I have tried this but now its giving me blanks. I have some questions:

Do I store the new result as a new variable? I tried both. Same results. All I get is blanks on the document generation.
I placed the apply the expression step after each variable to remove the decimals. Is this correct?