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.
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?