Re: Concat Currency with Text

ErnestoM — Wed, 03 Apr 2013 13:06:00 GMT

field1 might be displayed as currency on its own but it's stored as 50000 not $50,000.

You could try something like:

concat("The amount is $", substring(field1, 1, 2), ",", substring(field1, 3, string-length(field1)))

Concat Currency with Text

Baseball17Bucks — Tue, 02 Apr 2013 14:11:50 GMT

Hi,

I want to concatenate a field containing currency formatting with text in a Rich Text Box.

field1= $50,000.00

Text box formula --> concat("The amount is ", field1, " and it must be expended prior to March 01, 2014.")

This formula returns this in the text box... The amount is 50000 and it must be expended prior to March 01, 2014.

I want this to show up (with currency formatting)... The amount is $50,000.00 and it must be expended prior to March 01, 2014.

Thanks for the help!