Hi

I am trying to sort a rounding issue in Filemaker and struggling!

I have a unit cost field set as a number and rounded to 2 decimal places but Filemaker calculates the background figure

Example

Unit cost £0.825 / Displays as £0.83 / Line total calculates the pre rounded figure.

I have tried the Rounding Calculation - Round ( Item qty 1; 2)

That works if I change the field type to a calculation but not when asset as a number. This box needs to be editable, so needs to be a Number field.

Another option would be to display 3 decimal places but that looks odd when I have rounding figures like

£10 ( Displays £10.000 ). Is there a calculation to remove the last decimal place if it is a zero ?

The other idea I thought of was to change the field to a general field but I would need to add a "£" to the field once entered, so not sure if there is a calculation to insert a symbol and that might work ?

Any advice would be appreciated

Thanks

Neil

You can keep the field as a number if you use your calculation as an auto-enter using the Self function. So your calc would look like this:

Round ( self ; 2 )

As long as you uncheck the Do not replace existing contents option this would reset whatever value you enter (0.825) to two decimal places (0.83).