Solved

How to cast decimal to currency value in K2 Email event

  • 4 September 2018
  • 1 reply
  • 20 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

icon

Best answer by tbyrne777 4 September 2018, 16:49

View original

1 reply

Userlevel 5
Badge +13

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.

Reply