set analysis help

[Krish2459_58]

Hi,

I have the below if cause and I need to do this syntax in set analyis. Please help.

if(num([lease end date]) = num(Final_Term_Date) or isNull(Final_Term_Date) and [continuing occupancy] = "N*",[Lease ref])

Thanks..

[Krish2459_58]

@taotao886 don't use this community to promote gaming apps.

[Vegar · Accepted solution]

Why do you want to use SET analysis for this? Can't you use it as it is?

First. There are no aggregation  done in your example, in order to do set analysis you need to use a aggregation function such as avg or sum.

Second Set analysis is not optimal for the inter record comparisons that you are doing in the example, it is neither straight forward to implement the OR request.

Third. Null values complicates things in set analysis, because you can't explicitly select null values.

Unless you are keeping some information out of the post I suggest you keep your if statement.