Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
count({<[lease end date] = {"<=$(=AddMonths($(vTodaysDateNum), 18)) >$(vTodaysDateNum)"}, status = {"Current", "Live"}>} [Lease ref])
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])