Money formatting of Decimal places based on amount

[GaryJ]

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

[_ylc]

You can do something like

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