topic Re: respect fields decimal places when updating using formula in DemandTools

respect fields decimal places when updating using formula

Tiffany — Wed, 01 May 2024 17:12:21 GMT

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 ?

Re: respect fields decimal places when updating using formula

AnthonyValidity — Wed, 01 May 2024 18:31:59 GMT

Hi Tiffany!

What kind of field are you trying to update? What is the name of the field?

Regards,

Re: respect fields decimal places when updating using formula

Tiffany — Wed, 01 May 2024 18:34:05 GMT

It's a currency field. Currency(16, 2)

Re: respect fields decimal places when updating using formula

Tiffany — Wed, 01 May 2024 18:39:14 GMT

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.

Re: respect fields decimal places when updating using formula

AnthonyValidity — Wed, 01 May 2024 18:47:17 GMT

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,

Re: respect fields decimal places when updating using formula

Tiffany — Wed, 01 May 2024 18:50:49 GMT

That worked. Thanks so much!

Re: respect fields decimal places when updating using formula

AnthonyValidity — Wed, 01 May 2024 18:54:35 GMT

My pleasure! 🙂

Regards,