3 Replies Latest reply on Jul 11, 2013 6:43 AM by MilutinPetrovic

    Permanently store calculated resault

    MilutinPetrovic

      Title

      Permanently store calculated resault

      Post

           Hello friends,

           I have 3 number fields (Coef, Base, Net)  and the calculation field (Total) with a formula  ((Coef+Base)*Net)/0.701. 
           As I said, the result of a given formula is stored in the Total field. Now, the problem is that that 0.701 number is changed every once in a while, and I need the previously calculated values to remain the same when the number is changed, hence the "Permanently store calculated result" subject...

           Now, I can create the Global field for the value, or insert it directly in to the formula (preferred), but I would like to avoid the calculation script if possible!

            

           Any ideas?

           Thanks!