I am new to FileMaker and trying to update a rounding calculation in a script from 2 decimal point to 6, but it didn't update the calculation for all the previous records.
FTE = round ( x+y *2;2) to FTE = round (x+y*2;6)
FTE is a number type but the calculation is done through a script rather than Auto-Enter Calculation. How can I update all the previous records?
I read somewhere that Replace Field Contents can't be used for calculations. So what are my options?