batixan Posted March 7, 2012 Posted March 7, 2012 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.
comment Posted March 7, 2012 Posted March 7, 2012 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.
batixan Posted March 7, 2012 Author Posted March 7, 2012 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.
Lee Smith Posted March 7, 2012 Posted March 7, 2012 My choice would be to review the other fields involved and perhaps round them to 2 decimals. HTH Lee
Rick Whitelaw Posted March 8, 2012 Posted March 8, 2012 The sum should be the sum of rounded items. Rounding is not avoidable. Right now FM is rounding the sum.
normanicus Posted March 8, 2012 Posted March 8, 2012 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.
Recommended Posts
This topic is 4891 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now