Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, how do I write this formula to show the previous years data? This is my current year selection. I want to show how the data looked exactly the same time last year.
You can use Addyears function in your vDateStart and vDateEnd.
Addyears(vDateStart,-1)
Addyears(vDateEnd,-1)
it will return the start and end dates of the same period of last year
HI @WernerDC
Instead of If condition, Try with set analysis like below
sum({<dateEntry_det={">=$(=AddYears($(vDateStart),-1))<=$(=AddYears($(vDateEnd),-1))"}, serviceCode_det={30}>}qtyHa_det)
You can use Addyears function in your vDateStart and vDateEnd.
Addyears(vDateStart,-1)
Addyears(vDateEnd,-1)
it will return the start and end dates of the same period of last year
Thank you
HI @WernerDC
Instead of If condition, Try with set analysis like below
sum({<dateEntry_det={">=$(=AddYears($(vDateStart),-1))<=$(=AddYears($(vDateEnd),-1))"}, serviceCode_det={30}>}qtyHa_det)
Thank you