Formating Numeric Fields

[dpccgf]

How can I take a field that is showing in a CDML results page as 5000000 and show it at $5,000,000? I am hoping there is an easy answer. Thanks in advance!

[slstrother]

Create a calculation field resulting in text that formats the number the way you want it to appear, place this field on your web layout and use this field in your CDML tag.

Number_Formatted=

"$"&

Case(

Length(Number) <= 3,Number,

Length(Number) = 4,Left(Number,1)&","&Right(Number,3),

Length(Number) = 5,Left(Number,2)&","&Right(Number,3),

Length(Number) = 6,Left(Number,3)&","&Right(Number,3),

Length(Number) = 7,Left(Number,1)&","&Middle(Number,2,3)&","&Right(Number,3),

Length(Number) = 8,Left(Number,2)&","&Middle(Number,3,3)&","&Right(Number,3),

Length(Number) = 9,Left(Number,3)&","&Middle(Number,4,3)&","&Right(Number,3))

This calc goes out to 9 digits and places the commas in the appropriate place. If you always use even amounts (no cents) it should work for you.

[Garry Claridge]

Try:

[FMP-Field:myNumber,format]

Good Luck.

Garry