Can I change a field's calculation equation without affecting the existing results?
I have a data base called products with auto enter serial number turn on.
Currently, I have a calculation field with a fixed equation but I'm afraid that this equation may be changed in the future.
So, I'm wondering if it's possible to change the equation without affecting the existing value?
Say that I have 100 of records (serial number 1~100) with the current equation, and now I want to change the equation starting from serial number 101. Is it possible for me to change the equation but keep the calculation result unchanged for searial number 1~100 ?