topic Re: set analysis help in App Development

set analysis help

Krish2459_58 — Tue, 15 Apr 2025 05:24:21 GMT

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..

Re: set analysis help

Krish2459_58 — Tue, 15 Apr 2025 06:23:21 GMT

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

Re: set analysis help

Vegar — Tue, 15 Apr 2025 06:40:59 GMT

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.