Hello,
I'm trying to identify(output) where I have a value in "DirectLeaseRateLow" and a value in "DirectLeaseRateHigh" but NO value in "DirectLeaseRateType". I'm not worried about nulls or blanks.
I'm thinking it should be a conditional statement.
Attached is a snippet of the table.
Any help would be greatly appreciated. Thanks.
Solved! Go to Solution.
You could use the formula tool to add a flag or use the filter tool to filter out records. For the formula tool you would use something like:
IF !ISNULL([DirectLeaseRateLow]) AND !ISNULL([DirectLeaseRateHigh]) AND ISNULL([DiretLeaseRateType]) THEN 1 ELSE 0 ENDIF.
The filter tool would just use !ISNULL([DirectLeaseRateLow]) AND !ISNULL([DirectLeaseRateHigh]) AND ISNULL([DiretLeaseRateType])
Thanks Nick that worked!! Solved.