Exception output

[ashriva2]

Hi

I have a data which has 312 line item to validate, with the help of “filter tool”309 are valid exceptions and 3 three are actual exception on which I have to work. In the output file I need these 3 line item tagged as “Research” and 309 as “Valid exceptions”.

[cjaneczko]

Use a formula instead of a filter. In the formula tool Use an IF statement with the criteria used in your filter tool. If those 3 records match the criteria set the THEN statement to "Research", ELSE "Valid Exceptions".

IF [FIELD BEING TESTED] = (Criteria for 3 fields to be triggered) THEN 'Research' ELSE 'Valid Exceptions' ENDIF

[Towers · Accepted solution]

Hi @ashriva2,

This formula should work for you, I have attached an example for you.