function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Natalia Rex 1Natalia Rex 1 

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
 

CharuDuttCharuDutt
Hii Natalia Rex
Try The Below Formula 
(FTE__c*Estimated_Project_Months__c)*Stack_Budget__c

Please Mark It As Best Answer If It Helps
Thank You!
Natalia Rex 1Natalia Rex 1
Hello, thank you for writing. Yes multiple currencies are active, however, the main currency checked is EURO, and the currency formula I have is also checked as EURO as well.
Natalia Rex 1Natalia Rex 1
@CharuDutt - I tried what you said, however, I still got 904.11.
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?
 
ftyfy gyugyuftyfy gyugyu
I also want to make the same script for my new project of Sepco online bill (https://utilitybills.pk/sepco-online-bill/) that hosted on WordPress. I have done initial stage pages you can check.