Not adding the commas to the numbers when generating a document

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 ^[\d,]*

 

​@SimonMuntz 

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

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

   

   

   

    

​@SimonMuntz I even tried to do a replace in the expression with the following:

 

This gave me the number on the doc gen, however it now has the “” contained in the number.  

Any ideas?  :)