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.

 

Lease Rates.PNG

nick_ceneviva

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])