Conditonal Statement Help

[Stephenw_Keith]

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.

 

[nick_ceneviva · Accepted 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]) 

[Stephenw_Keith]

Thanks Nick that worked!! Solved.