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!
Solved! Go to 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.
Thank you all! I didn't have the right If THEN statement thought out. Thanks again!
@whitkrieng You're welcome !