2 weeks ago
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.
2 weeks ago
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,
2 weeks ago
Hi Tiffany!
What kind of field are you trying to update? What is the name of the field?
Regards,
2 weeks ago
It's a currency field. Currency(16, 2)
2 weeks ago
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.
2 weeks ago
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,
2 weeks ago
That worked. Thanks so much!
2 weeks ago
My pleasure! 🙂
Regards,
Get industry news, expert insights, strategies, and hot tips, served up fresh every week.
Visit the Validity blog