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!