Skip to main content
Nintex Community Menu Bar
Solved

How to cast decimal to currency value in K2 Email event

  • September 4, 2018
  • 1 reply
  • 43 views

Hi,

 

I have a decimal field in my database say 102233112.32 and would like display the data in K2 Email event as 

Total X: 102,233,112.32 barrels

 

 

Please help me in casting the text

Best answer by tbyrne777

How are you reading in this data to include in an e-mail? Via SmartObject tied directly to your database or some other approach? Assuming the former, you can use the "Format" function when customizing your message - drag out the Format function and it will prompt you for parameters, drag in your currency data field as a parameter and it should then format it for you at run time.

1 reply

Forum|alt.badge.img+15
  • Scholar
  • Answer
  • September 4, 2018

How are you reading in this data to include in an e-mail? Via SmartObject tied directly to your database or some other approach? Assuming the former, you can use the "Format" function when customizing your message - drag out the Format function and it will prompt you for parameters, drag in your currency data field as a parameter and it should then format it for you at run time.