We have a numeric field which should produce a result with decimal points after multiplication in workflow field update.
We are using two fields(one formula, one numeric) for multiplication in formula, both round down to two decimal places.
However, the decimal part is not coming correctly after field update. All fields in the formula have 2 decimal places in their setup.
Field 1 : Margin_per_ton__c : formula field ( Net_Price_per_ton__c - Delivered_Cost_per_ton__c ) upto two decimal places.
Field 2 : Quantity : Number (10,2)
For eg : -
- Margin_per_ton__c = 115.51 ,
- quantity = 250
- Value from Workflow field update = 28,878.25
- Actual calculation = 28,877.5