AnsweredAssumed Answered

Permanently store calculated resault

Question asked by MilutinPetrovic on Jul 11, 2013
Latest reply on Jul 11, 2013 by MilutinPetrovic


Permanently store calculated resault


     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?