Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Got it to work:
Sum({<Status={'Avslutad'},[Agreement_startdate.autoCalendar.Year]={"$(=Year(Today()))"}>}Estimatedvalue)
Tried it, does not work.
Can get it to work with just '2019' and '2018'.
Got it to work:
Sum({<Status={'Avslutad'},[Agreement_startdate.autoCalendar.Year]={"$(=Year(Today()))"}>}Estimatedvalue)