Set analysis

[Krish2459_58]

Hi,

Please seggest to get setanalysis expression for the below if logic.

if(num([lease end date])<Addmonths($(vTodaysDateNum),18) and num([lease end date])>$(vTodaysDateNum),if (match(status,'Current','Live'),count([Lease ref]),0),0)

Thanks..

[F_B]

count({<[lease end date] = {"<=$(=AddMonths($(vTodaysDateNum), 18)) >$(vTodaysDateNum)"}, status = {"Current", "Live"}>} [Lease ref])

[MeehyeOh]

HI, @Krish2459_58 

I think it will be possible with the formula below.

Is the [release end date] field the date type field? If so,apply date format in the [release end date] field to 'dateformat'.

 Count({< [lease end date] = {">$(=Date($(vTodaysDateNum),'dateformat))' <$(=Date(Addmonths($(vTodaysDateNum),18),'dateformat'))"}, status = {'Current', 'Live'} >} [Lease ref])