Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=count({< Year={$(vPrevYear)}, Pay_Period=, Number_Day={$(vMaxDay)} >}DISTINCT(People_ID))
=count({< Year={$(vPrevYear)}, Pay_Period=, Number_Day={$(vMaxDay)} >}DISTINCT(People_ID))