AnsweredAssumed Answered

Prevent calculation from recalculating

Question asked by JohhnyHilly on May 26, 2013
Latest reply on May 27, 2013 by philmodjunk


Prevent calculation from recalculating


     How do you prevent a calculation from recalculating? I have a calculation field that is based on 2 fields on the same table. If I change one of those fields, I don't want the calc field to alter at all.

     Under Storage Options I have "Do not store calculation results -- recalculate when needed" unchecked, so it shouldn't recalculate when one of the 2 fields are changed. The idea behind this is the calc field is a primary key and I don't want the primary key/ID number to change ever, but the Company name may change over it's life which is what the primary key calc field is based on.