Using MultiField Tool to NULL certain columns based on a certain condition

[whitkrieng]

daystoclose	storeid	dealnumber
22	1234	ABC123
240	1245	ABC124
10	1122	AAB112
211	1123	ABB113

I don't know if this is possible but I am trying to NULL out rows over a number of columns (def more than the 2 shown here), therefore I was wondering if this is possible to do in the MultiField Formula Tool. 

I want to apply a condition in the expression as in: If [daystoclose] > 100 then (make [CurrentField] = NULL) else (keep value in [CurrentField]) end if.

So the final result would look like this: 

daystoclose	storeid	dealnumber
22	1234	ABC123
240	[NULL]	[NULL]
10	1122	AAB112
211	[NULL]	[NULL]

Thank you for everyone's help and feedback!

[BrandonB · Accepted solution]

Hi @whitkrieng 

This formula will work for you:

IF ToNumber([daystoclose])>100
THEN Null()
ELSE [_CurrentField_]
ENDIF

Just make sure that you have daystoclose UNCHECKED in the configuration, you have it set to "All Types of" fields, and you have "Copy Output Fields and Add" UNCHECKED.  Example screenshot below. 

[Emmanuel_G · Accepted solution]

@whitkrieng ,

One way to do this

[whitkrieng]

Thank you all! I didn't have the right If THEN statement thought out.  Thanks again!

[Emmanuel_G]

@whitkrieng  You're welcome !