To filter a custom report to show only regular employees, which comparison type should you use?

To filter a custom report to show only regular employees, which comparison type should you use?

• A. Contains
• B. Is Equal To
• C. Starts With
• D. Is Not Equal To

Answer: (B)

To show only regular employees, you need an exact match on the status value. Using the Is Equal To comparison type compares the field (such as Employee Status or Employee Type) to the exact value you specify, like "Regular." This returns only rows where the status is exactly Regular. Other options would broaden the result: Contains would pull any row whose status includes the word, which could include unintended values; Starts With might capture multiple statuses that begin with the same prefix; Is Not Equal To would exclude only the exact match and still include many non-regular cases. So exact equality ensures you select only the regular employees.

To show only regular employees, you need an exact match on the status value. Using the Is Equal To comparison type compares the field (such as Employee Status or Employee Type) to the exact value you specify, like "Regular." This returns only rows where the status is exactly Regular.

Other options would broaden the result: Contains would pull any row whose status includes the word, which could include unintended values; Starts With might capture multiple statuses that begin with the same prefix; Is Not Equal To would exclude only the exact match and still include many non-regular cases. So exact equality ensures you select only the regular employees.