FormatCurrency inconsistent

1

I know this is an experimental function, but I’m having a lot of trouble getting currencies to display correctly - $12,345.56.

FormatCurrency seems to work differently depending on whether or not it’s combined with other functions.

See screenshot for an example. (The $ symbol is shown in the 2nd example because I added it manually.)

Any suggestions on how I can display currency consistently?

Coda currency format
Coda currency format1024×1200 34.6 KB

1 Like
2

Hi @Graydon_Trusler,
I guess the issue is not in the formula itself, rather in using the plus sign (+) to concatenate strings: discouraged as this is not how Coda implements String concatenation.

In order to do this, you can either use the Concatenate() formula:

Concatenate("There is a balance due of $", FormatNumber(thisRow.[Balance Due], true, 2))

or - preferred, but it’s my personal choice - Format()

Format("There is a balance due of ${1}", 
  FormatNumber(thisRow.[Balance Due], true, 2)
)

I hope this helps.
Cheers!

5 Likes
3

Thanks @Federico.Stefanato - that worked perfectly!

2 Likes