Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
GaryJ
Partner - Contributor

Money formatting of Decimal places based on amount

A customer wants the sum of Money amounts to show 2 decimal places when < 1000 example $999.99 and no decimal places if > 1000 $9,999. I can easily set this to be 2 decimal places, but haven't found a way to remove the decimal once the amount is over a configured value. I have searched, but haven't been able to locate a solution. Has anyone encountered this and how was it handled? Thanks in advance

Labels (1)
1 Reply
_ylc
Partner - Creator

You can do something like

IF(Sum(Sales)<1000, NUM(SUM(Sales), '$#,###.##'), NUM(SUM(Sales), '$#,##0'))