When creating record selection formulas that include If statements, always include the Else keyword; otherwise, no records or unexpected records may be returned. For example, a record selection such as If {parameter field} = "less than 100" then {field} < 100 evaluates as False and returns no records. To correct this problem, complete the formula with Else True.