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
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