+14I'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.
Best answer by TomaszPoszytek
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.
+17First, 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.
+14Thanks 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>
+17But 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?
+14I tried this and it worked. Thanks Tomasz!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.