
Partner - Contributor
2020-02-25
12:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1 Reply

Partner - Creator
2020-02-25
09:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can do something like
IF(Sum(Sales)<1000, NUM(SUM(Sales), '$#,###.##'), NUM(SUM(Sales), '$#,##0'))
