Newbie: 2 decimals

[Michael H]

In a field with as type calculation i have tried these:

Truncate((Ammount_1*Price_1);2)

Truncate(Ammount_1*Price_1;2)

Round((Ammount_1*Price_1);2)

Round(Ammount_1*Price_1;2)

The problem is i want 2 decimals and it will give me two if the calculation without truncating/rounding has 2 or more decimals but otherwise it won't.

Any help would be very appriciated,

Michael

[LiveOak]

You are looking in the wrong place. Truncation or rounding control the MAXIMUM number of decimal places in a calculated result. If you want "2" to display as "2.00" it is a display formatting issue and not a calculation issue. From a mathematical calculation standpoint 2 and 2.0000 are the same.

In layout mode select the field, go to the Format menu, select "number..." and set the number of decimal digits to be displayed.

Truncation to three places will change 3.1415 into 3.141. Rounding to three places will change 3.1415 to 3.142. Both leave 3 as 3.

-bd

[Michael H]

Arg.. i should have know that...

Thanks

[Vaughan]

Just a clarification... say a field on a layout was formatted to display 3 decimal places, and 3.1415926 was entered into the field. It will display as 3.142 *but* when used as a calculation the entered value of 3.1415926 will be used.

Under certain circumstances the difference between the displayed value and stored value can cause (apparent) discrepancies in calculations.