Reports with number format $#,###0.00 misplaces the comma.
I tested if I switch the format to $#,###.## then it has no problem with commas.
We do not see any misplaces here.
Please note that you define with 4 number between your “,” and “.”, so that the result in Ragic report follows this format.
“$#,###0.00” is not a standard format, if you do not need 4 number in between, you should change it to “$#,##0.00”
Amy, you are right! What I want is “$#,##0.00” not “$#,###0.00”
However the strange thing is that I have “$#,###0.00” in the form page and it shows $0,000.00
That is why I couldn’t see the error.
1 Like