Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Formatting Currency in a table column

Created: 06 Feb 2013 | 2 comments

In Workflow 7.5 I am using the Send Email component and trying to format a table from an array.  My array is returning a cost values as a decimal.  I would like to display this value in an email as currency.  I have tried using both the "html table from collection" and the "Table from array" formatters in the email component.  There seems to be several ways to format columns but I don't see a way to format these values as currency.  Does anyone know how this can be done? 

Comments 2 CommentsJump to latest comment

africo's picture

one way off the top of my head is to format as Number(Decimal) and merge in a dollar sign.

rhamner's picture

Unfortunately, this editor doesn't let you specify a column format like the Grid UI component. One easy option I can think of is to create a second version of the data-type you're working with that has a string instead of decimal for the currency. Before the send email component iterate through your data-type to build display version with the dollar sign.

It wouldn't be a bad feature to have a format property on columns in the Build HTML Table component.