AnsweredAssumed Answered

To use or not to use Auto-Enter Calculation; that is the question.

Question asked by Reast on Jun 1, 2011
Latest reply on Jun 2, 2011 by philmodjunk

Title

To use or not to use Auto-Enter Calculation; that is the question.

Post

I have a manufacturing database in which there are several calculation fields that, in special circumstances, a user may need to override the calculation result and instead enter a different value.  Since calculation fields cannot be modified by a user, I thought the solution would be to change the calc field to an auto-enter calculation; thus, allowing the user to override the result when necessary.

Unfortunately, those auto-enter calculation fields are not evaluating.  I am instead getting a "?" as a result.  The calculations are painfully simple; e.g., "Quantity A/1000" or "Lbs Glue Ndd * Quantity A," etc.  The fields evaluated fine when they were straight calc fields and I cannot figure out what a solution might be.  I have a feeling my eyes are crazy crossed on this one.

I would love any guidance as to how I can accomplish my initial goal of allowing a user to override a calculation field - it seems I missed the mark with my thought of a straight Auto-Enter Calculation field.

Thanks!

Outcomes