You need to sign in to do that
Don't have an account?
Simple multiplication ends up with the wrong value - what is wrong?
Hi developer community :) I have perhaps a silly question but I keep checking what is wrong with this set up.
I have a simple formular (currency) field that needs to show a value of 3 numbers being multiplied!
My formula:
FTE__c*Estimated_Project_Months__c *Stack_Budget__c
FTE = Is a number field, with 2 decimal points
Estimated project months = A formula that generates a number
Stack budget = a Currency Number
I keep getting a wrong number.
For example: FTE =5, Project Months = 9, and Stack Budget 20.00 Euro
Based on my formula it is 5 x 9 x 20 = 900.
However, in the field with the formula, I get: 904.11 and I have no idea from where.
Could you help?
Thank you
Try The Below Formula
Please Mark It As Best Answer If It Helps
Thank You!
I found the following formula, and it ended up being correct:
ROUND(FTE__c,1) * ROUND(Estimated_Project_Months__c, 1) *ROUND(Stack_Budget__c,1)
What I am wanting to know - how come this formula above worked? How come I had to round it to get the correct number, which is: 900.00
Im worried that maybe some setting is wrong, or something wrong w/ the currency, that is causing this?