Last Month Count

[sunil-kumar5]

Hi All,

Can anyone please help me to correct the below expression?

count({$<SoftwareType={'ABC'},LicenceNo={"=(DueDate+60<='$(=Date(Today()))')"},[Inst.Year]={'$(=Year(Today()))'}, [Inst.Month]={'$(=Month(Addmonths(Today(),-1)))'}>}Distinct LicenceNo)

So basically I have two different KPI but I want to merge it in one to get the last month count based on type and LicenseNo.

First -  count({$<SoftwareType={'ABC'},LicenceNo={"=(DueDate+60<='$(=Date(Today()))')"}>}Distinct LicenceNo)

Second- count({<[Inst.Year]={'$(=Year(Today()))'}, [Inst.Month]={'$(=Month(Addmonths(Today(),-1)))'}>}Distinct LicenceNo)

Thanks

[Anil_Babu_Samineni]

Is there any error you see in the given expression, also I usuallt use internal analysis always double quote ("") instead ('')

[sunil-kumar5]

Hi Anil,

It does not give any error but result is zero which is not possible. Also I used it with double quotes but not result.

Please advise.

Thanks

Sunil Kumar

[Anil_Babu_Samineni]

Is First and Second expressions are working individually correctly?

[sunil-kumar5]

Yes, they are absolutely fine