Max Year Kpi but you can accumulate numbers if you add more years

[Alarkis]

Hello all,

I have a KPI that uses max year to show result of the maximum year i want to keep it but i want the kpi to add the result of all selected years aswell currently it only select result of year selected

also Month, Quarter..

expresssion used:

Count({<Year={$(vMaxYear)},DateType={'Application_Date'}>}distinct [Applicant Id.])

i hope its clear.

[Vegar]

It was not completely clear, but I'll give it a shot.

Try this:

Count({<Year +={$(vMaxYear)},DateType={'Application_Date'}>}distinct [Applicant Id.])

i

[Alarkis]

Thank you for replying.

I want it to appear like this:

Count({<Year={$(vMaxYear)},DateType={'Application_Date'}>}distinct [Applicant Id.])

but be able to accumulate the results when selecting years.

currently i am able to select 1 years only.

with your expression it would accumulate all years by default which i dont want.

Regards.

[Vegar]

What is the content of your variable vMaxYear? I  might be that one that is causing you trouble.

Maybe an expression like this will be able to solve your issue.

Count({<Year={'$(=max(Year))'},DateType={'Application_Date'}>}distinct [Applicant Id.]