AnsweredAssumed Answered

Update Calculations in Script doesn't update all previous records

Question asked by mchopra94 on Feb 19, 2019
Latest reply on Feb 20, 2019 by user19752

Hi All,

 

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?

Outcomes