cancel
Showing results for 
Search instead for 
Did you mean: 
Nintex Employee
Nintex Employee

Format number variable as currency in Nintex Workfow for Office 365

Jump to solution

I'm using Nintex Workflow for Office 365.  I'm trying to figure out how to display a number that is stored in a number type workflow variable as formatted currency in an email.

So I'd like the number 12345 that's in a number type workflow variable to display as $12,345.00 in the email.

Labels: (1)
0 Kudos
Reply
5 Replies
Automation Master
Automation Master

Re: Format number variable as currency in Nintex Workfow for Office 365

Jump to solution

First, be sure your variable is a "Number" type.

Then, when composing "Body" of your e-mail click the "Advanced Lookup" link, then choose your variable, and after it is chosen click the little "fx" icon next to its name. On the popup pane choose "Formatted Currency".

It should format the number according to the regional settings of your tenant (I hope so...), but I think the "$" character you must add manually.

View solution in original post

Reply
Nintex Employee
Nintex Employee

Re: Format number variable as currency in Nintex Workfow for Office 365

Jump to solution

Thanks Tomasz.  That's definitely helpful.

What I failed to mention is that I'm trying to build a HTML string in my workflow that displays the formatted currency column inside of a column in a table row.  That string will then appear in the email.  So something like:

<tr><td>Total Cost</td><td>{Variable:numTotalCost}</td></tr> 

0 Kudos
Reply
Automation Master
Automation Master

Re: Format number variable as currency in Nintex Workfow for Office 365

Jump to solution

But even though you should be able to insert variable using advanced lookup option, where you can choose format of the inserted value. Have you tried that? 

Reply
Nintex Employee
Nintex Employee

Re: Format number variable as currency in Nintex Workfow for Office 365

Jump to solution

I tried this and it worked.  Thanks Tomasz!

0 Kudos
Reply
Automation Master
Automation Master

Re: Format number variable as currency in Nintex Workfow for Office 365

Jump to solution

‌ does my answer helps?

0 Kudos
Reply