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

    How to change a calculation formula without affect old records?


      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!!!