KPI by year and status

[thom_sundberg]

Hi,

I am trying to filter KPI by status and year, but cant get it to work with year. What am I doing wrong?

Sum({<Status={'Avslutad'},[Agreement_startdate.autoCalendar.Year]={"=Year(Today())"}>}Estimatedvalue)

Thanks in advance

[Vegar]

Try
Sum({<Status={'Avslutad'},[Agreement_startdate.autoCalendar.Year]={"=$(=Year(Today()))"}>}Estimatedvalue)

[thom_sundberg]

Tried it, does not work.

Can get it to work with just '2019' and '2018'. 

[thom_sundberg · Accepted solution]

Got it to work:

Sum({<Status={'Avslutad'},[Agreement_startdate.autoCalendar.Year]={"$(=Year(Today()))"}>}Estimatedvalue)