Hello,

I have a field that contains a calculated result. Actually it is the sum of the line items.

Sometimes the invoice of a corporation has the sum of 1167,06 and when i enter the products to an invoice of my database i get the total as 1167,07.

In order to control my payments it would help me to have the same result exactly. So, it would be helpful to have a calculated field that at the same time to be editable, so when i have problems as i described above to have the option to enter the sum manually.

thank you in advance.

You could use a Number field with auto-entered calculated value. Or define a separate Adjustment field and have the calculation add it at the end.

You could use a Number field with auto-entered calculated value. Or define a separate Adjustment field and have the calculation add it at the end.

Thanks comment,

I have already done it. I mean the Adjustment field. It works.

My choice would be to review the other fields involved and perhaps round them to 2 decimals.

HTH

Lee

The sum should be the sum of rounded items. Rounding is not avoidable. Right now FM is rounding the sum.

Make a case statement where the first condition and result depend on an editable field:

Case(

not IsEmpty ( FieldXYZ ) ; FieldXYZ ;

Condition 2: Result 2 ;

etc.

)

That way the calculation result it the contents of the field if there is one, otherwise the calculation.