same day last year expression

[saifuddin]

Hi All,

I need some help with a problem I am trying to solve. 

I am trying to

--count distinct People_ID for the selected year, selected Pay_period and on the Max Number_day which from user selection. (works fine)  =count({$< Number_Day={'$(=$(vMaxDay))'} >}(People_ID))

--Count People_id for the previous year of the selected year but for the same Number_Day as currently selected year and disregarding Pay_Period selection.

Example:

For the above data in excel file. Below is the current selection.

=count({$< Number_Day={'$(=$(vMaxDay))'} >}(People_ID))  Result 3

$vMaxDay=6

Previous year from my calculation

=count({$< Year={$(=Year-1)},pay_period=, Number_Day={'6'} >}DISTINCT(People_ID))

And Result of count should be 1.

I added 6 manually. It’s basically  max Number_Day of the current selection. Number_Day has to be dynamic.

Appreciate your help

Regards

Saif 

[Claudiu_Anghelescu · Accepted solution]

=count({< Year={$(vPrevYear)}, Pay_Period=, Number_Day={$(vMaxDay)} >}DISTINCT(People_ID))