I've written a small script to compare two values and then set a field if the condition is verified.
If [ TableName:BdFt < TableName:InitialBdFt ]
Set Field [ TableName:Discrepancy ; "Yes" ]
For some reason the IF ( ) function is not working. Using Script Debugger and Data Viewer I've stepped through the script and verified the values for BdFt, InitialBdFt and each time the value for BdFt is less than InitialBdFt the Discrepancy field is never set.
All three are record fields in the same table.