9 Replies Latest reply on Mar 21, 2016 4:21 AM by Mike_Mitchell

    How to change a calculation formula without affect old records?

    Angelus81

      I have a calculation that calculate how many glue is using per each product during production.

      Below is one of my calculation:

       

      Case (

      Unit = "PARR" ; QTY * 2 * Glue_Usage::DJ_11 / 1000 ;

      QTY * Glue_Usage::DJ_11 / 1000

      )


      However, now one of the product's glue usage is changed, if I update it on my filmmaker database, it will also affect my old record.


      In this case, what should I do?


      Please HELP!!!