- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ05-01-2024 10:12 AM
I am using this formula (${Commission__c}/100)*${Total_Price__c} to update a currency field with 2 decimal places, it returns more decimals and causes the next user to edit the object to get an error. Example data (16.2/100)*772.23 populates 125.10126 in the currency field. Is there a way I can have it return 125.10 ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ05-01-2024 11:47 AM
Hi Tifanny,
I believe you would just have to add the TEXT formula on the outsdie of your calculation to make sure it is formated with two digits after the decimal. Here's an example to try TEXT(${Commission__c}/100)*${Total_Price__c},"0.00") .
Hope this helps,
Senior Customer Success Manager
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ05-01-2024 11:31 AM
Hi Tiffany!
What kind of field are you trying to update? What is the name of the field?
Regards,
Senior Customer Success Manager
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ05-01-2024 11:34 AM
It's a currency field. Currency(16, 2)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ05-01-2024 11:39 AM
I wanted to do the formula in the SFDC field itself, but we need this field to not be a formula field. So I was hoping I could get the formula done and field updated through demandtools on a schedule.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ05-01-2024 11:47 AM
Hi Tifanny,
I believe you would just have to add the TEXT formula on the outsdie of your calculation to make sure it is formated with two digits after the decimal. Here's an example to try TEXT(${Commission__c}/100)*${Total_Price__c},"0.00") .
Hope this helps,
Senior Customer Success Manager
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ05-01-2024 11:50 AM
That worked. Thanks so much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ05-01-2024 11:54 AM
My pleasure! ๐
Regards,
Senior Customer Success Manager

