0

We have a currency field which should produce a currency result with decimal points after multiplication. However, the decimal part was consistently round down to zero. All fields in the formula have 2 decimal places in their setup.

enter image description here

I could only fix it by doing the following:

ROUND(Bill_to_Account_formula__c, 2) * Number_of_Payments_For_This_Pay_Line__c

It does not work this way:

Bill_to_Account_formula__c, 2 * Number_of_Payments_For_This_Pay_Line__c

does anyone know what is the reason that this formula did not produce correct decimal points before we used ROUND operation?

0

ROUND(Bill_to_Account_formula__c, 2) * Number_of_Payments_For_This_Pay_Line__c

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.