Is == #MISSING valid in an IF statement
I am trying to debug a seldomly used code snippet, and cannot determine why it does not work.
A SmartList was created in Planning for Overhead Calculated, with the values
Yes #missing
No 1
A Planning form was used to set the values, and I can query the data using Excel to confirm the data points are where they should be.
A calc script has:
"Overhead_Calculated"
(IF("ValidOHFee"->"No Location"->"Inflated_Value" == #MISSING)
"Overhead_Calculated" = some crazy algebra calculation ;
)
It appears the IF is ignored, and Overhead_Calculated is done for everything.
I know with PLSQL, referencing a NULL value is very unreliable, so I wonder if this is an unreliable way of doing this. Maybe it should be <> 1 or != 1.