Using the Currency Symbol in the Layout tab of the Display Template

[Former Member]

In xMII 11.5 SP3, I'm trying to format a number in a grid template with the USD ($) symbol. In looking through the 'Number format' help screen, I see I'm supposed a symbol that I can't identify in an ASCII table (though I did find it in an EBCDIC table). I can't show you the symbol - if I could I wouldn't have to post this message!

How do I use this symbol?

David Macindoe

[jcgood25 · Accepted solution]

David,

You should be able to use something simple like: $#,##0.00

Regards,

Jeremy

[Former Member · Accepted solution]

Thanks, Jeremy. I had previously tried $000.00 but all I got was 118.27. I just can't get the dollar sign to display which led me to the help screen and the symbol that I can't reproduce.

After your reply, I changed the display template to $#,##0.00 with no change in the result. I'm putting this in the Format column on the Layout tab of a vertical grid display template.

David

[jcgood25 · Accepted solution]

Is the column actually known as a number? From your iGrid do a Right-Click...Data Details and hold down the Control key to get XML results. Then look at the SQLDataType attribute for the column you are attempting to format.

Regards,

Jeremy

[Former Member · Accepted solution]

That's what it was, Jeremy! SQLDataType="1" Thanks for the help.

David