### Forum

## Calc Builder Support

Calc Builder supportForums

Public write access is disabled. Please login

### decimal points and calculation error 13.03.2013 15:35

Hello.

I built a form, and added the decimal points in php as the commas and dec points weren't rendered even though I added in preferences.

I do have joomla 1.5 version. My calculations do else work fine, but not the last one:

$kontrol=0.25;

$fejlreg=10;

$time=60;

$indtast=5;

$maaneder=12;

$faktor=1.2;

$timertot=1850;

$result_1=$num1*$kontrol*$maaneder*$num2;

$result_1=number_format($result_1,2,',','.');

$timer_1=$num1*$kontrol*$maaneder;

$result_2=(($num1*$fejlreg)/$time)*$num2*$maaneder;

$result_2=number_format($result_2,2,',','.');

$timer_2=(($num1*$fejlreg)/$time)*$maaneder;

$result_3=(($num1*$indtast)/$time)*$num2*$maaneder;

$result_3=number_format($result_3,2,',','.');

$timer_3=(($num1*$indtast)/$time)*$maaneder;

$ratio=(($num2*$num1*$timertot)/100);

$ratio=number_format($ratio,2,',','.');

$result=$result_1+$result_2+$result_3+$ratio;

$result=number_format($result,2,',','.');

Frontend result:

result_1 ok

result_2 ok

result_3 ok

ratio ok

result wrong

url: http://www.dynaway.com/roi

Anybody out there who can tell me what I did wrong?

Thank you in advance

Kind regards

Jeannine

I built a form, and added the decimal points in php as the commas and dec points weren't rendered even though I added in preferences.

I do have joomla 1.5 version. My calculations do else work fine, but not the last one:

$kontrol=0.25;

$fejlreg=10;

$time=60;

$indtast=5;

$maaneder=12;

$faktor=1.2;

$timertot=1850;

$result_1=$num1*$kontrol*$maaneder*$num2;

$result_1=number_format($result_1,2,',','.');

$timer_1=$num1*$kontrol*$maaneder;

$result_2=(($num1*$fejlreg)/$time)*$num2*$maaneder;

$result_2=number_format($result_2,2,',','.');

$timer_2=(($num1*$fejlreg)/$time)*$maaneder;

$result_3=(($num1*$indtast)/$time)*$num2*$maaneder;

$result_3=number_format($result_3,2,',','.');

$timer_3=(($num1*$indtast)/$time)*$maaneder;

$ratio=(($num2*$num1*$timertot)/100);

$ratio=number_format($ratio,2,',','.');

$result=$result_1+$result_2+$result_3+$ratio;

$result=number_format($result,2,',','.');

Frontend result:

result_1 ok

result_2 ok

result_3 ok

ratio ok

result wrong

url: http://www.dynaway.com/roi

Anybody out there who can tell me what I did wrong?

Thank you in advance

Kind regards

Jeannine

### Re: decimal points and calculation error 13.03.2013 15:54

Hello,

You´re trying to add $result_1 and $result_2 and so on to get $result. The problem is that $result_1 is a String, not a number. You should save $result_1 as number before applying number_format function and then use it.

Code looks like this:

Hope this helps.

Moonsoft Team

www.moonsoft.es

You´re trying to add $result_1 and $result_2 and so on to get $result. The problem is that $result_1 is a String, not a number. You should save $result_1 as number before applying number_format function and then use it.

Code looks like this:

...

$result_1=$num1*$kontrol*$maaneder*$num2;

$result_1_int=$result_1;

$result_1=number_format($result_1,2,',','.');

...

$result=$result_1_int+$result_2_int+$result_3_int+$ratio_int;

$result=number_format($result,2,',','.');

Hope this helps.

Moonsoft Team

www.moonsoft.es

### Re: decimal points and calculation error 18.03.2013 09:24

Thank you so much for helping! It's still not working right, unfortunately.

shouldnt that as well define the variables as numbers: $result_1=number_format($result_1,2,',','.');?

I know that if you try the calculation with 200 employees and 135 wage you finally should retrieve following numbers:

Fejlratio:

(1,2 % af den årlige lønomkostning)

Omkostninger: 499.500,00 kr. pr. anno

-> should be: 600.000,00

TOTAL= 108.054,00

-> should be: 763.620,00

shouldnt that as well define the variables as numbers: $result_1=number_format($result_1,2,',','.');?

I know that if you try the calculation with 200 employees and 135 wage you finally should retrieve following numbers:

Fejlratio:

(1,2 % af den årlige lønomkostning)

Omkostninger: 499.500,00 kr. pr. anno

-> should be: 600.000,00

TOTAL= 108.054,00

-> should be: 763.620,00

### Re: decimal points and calculation error 19.03.2013 12:08

Hello,

Number format is not used to define variables as numbers, but to format them. So, you only have to perform all calculations without using number_format function and once all results are calculated execute number_format function as the last lines of your calculators.

Regards,

Moonsoft Team

www.moonsoft.es

Number format is not used to define variables as numbers, but to format them. So, you only have to perform all calculations without using number_format function and once all results are calculated execute number_format function as the last lines of your calculators.

Regards,

Moonsoft Team

www.moonsoft.es