topic Re: Cy vs PY in Search the Community

Cy vs PY

WernerDC — Mon, 12 Apr 2021 08:56:48 GMT

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.

Re: Cy vs PY

MuhammadFahim — Mon, 12 Apr 2021 09:28:11 GMT

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

Re: Cy vs PY

WernerDC — Mon, 12 Apr 2021 09:43:43 GMT

Thank you

Re: Cy vs PY

MayilVahanan — Mon, 12 Apr 2021 09:48:17 GMT

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)

Re: Cy vs PY

WernerDC — Mon, 12 Apr 2021 11:34:42 GMT

Thank you