Skip to main content
Nintex Community Menu Bar

Hi everyone

I have a SharePoint column which is created as currency with two decimal places.

When I use this column in a Nintex Workflow Cloud workflow, the value returned only has one decimal place instead of two. 

How do I add another decimal to the number.

Example: “Cost” created as currency in SharePoint Online

The output of “Cost” should look something like R200.00, but in e-mails from Nintex the output from “Cost” is R200.0. How do I add the extra zero so that is displays with two decimal places?

Thanks

Hi ​@kirkie4567,

Have you tried using the Format number to string action before inserting the value into your email?
https://help.nintex.com/en-US/nwc/Content/Designer/Actions/FormatNumbertoString.htm

I did try that. But that action doesn't have the currency I want to use

After the convert to string action use a regular expression to replace the currency symbol. 

Hi ​@kirkie4567 
Have you solved your question?

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings