Hello,
I'm struggling with some odd behavior while trying to format currency
amounts. When the number is negative and 7-digits long, the picture string
is not working properly.
You should (I hope!) be able to replicate the issue in the GUI:
format-number(-999999, "$#,##0")
*Result:* -$999,999 <-- Expected Result
format-number(-9999999, "$#,##0")
*Result:* -$9999,999 <-- *Comma is in the wrong place*
format-number(-99999999, "$#,##0")
*Result:* -$99,999,999 <-- Expected Result
Am I missing something here?
Thank you!