AnsweredAssumed Answered

Why If Function Is Not Working

Question asked by Scorpion167 on Aug 16, 2018
Latest reply on Aug 20, 2018 by NorbertWeiss_1

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" ]

End If


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.