3 Replies Latest reply on May 9, 2012 10:19 AM by philmodjunk

    Storing calculation



      Storing calculation


      Hi. I have payment A, payment B and Answer fields. The field "payment B" is a global field. The 'answer' field is a calculation field payment A + payment B. After creating many records , I have to change the value of the global field 'payment B'. I don't want the old records to be changed. The question is :

      Will the old records change whenever I change the global field ?

      If yes, how can I store old records?


      Thanks in advance :D

        • 1. Re: Storing calculation

          Yes, they will change if they are fields of type calcualtion.

          No, they will not change if they are number fields with an auto-entered calculation.

          This second option may be the way to go if you do not want changes to the value in the global field to update the computed value in your field. You can convert a calculation field to a number field with an auto-enter calculation very easily. When you change it to type number the current value of the calculation is stored as the number in the field. If you then open field options and select the options for an auto-entered calcualtion, you'll find your original calculation from the calculation field already entered for you.

          • 2. Re: Storing calculation

            It means that if I use a field with auto-entered calculation, the field will stores value even if the global fields has be changed?

            • 3. Re: Storing calculation

              Do a few tests and see what works best for you. Is the global field defined in the same table as the data field? Did you select or clear the "do not replace existing value.." option?

              These details are key to what will happen when the value in the global field is changed and how it will function for you. With "do not replace existing value" enabled, the initial value computed when the record is created is the only value you'll see. I don't know if that works for you or not.

              If you define the global field in a different table, changes to it will not update this field in existing records even if the "do not replace..." option is cleared for that field.