Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to mesure yearly membership full-time of salaries,there is some salaries have diffent part-time from period to period.
For exemple: salary x have in 2018 part-time=0,9 and in 2019 part-time =0,5
the issue here that i get the sum of 0,9 + 0,5=1,4 but in my case i want to get the last occuenrce 0,5 not the sum of part times,see the attached screenshot.
My Set analysis is :
Count({$<__Pivot_Intervall_PeriodType ={'Intervall'}
, __Pivot_Intervall_Role={'EntreeSortie'}
, __Period_id = {'$(vdate_analyse)'}
,[__Status.FR] = {'(Actif)'},
[__Contract_Type]-={'IN','PS','TV','ST'}>}
distinct(__FOLDER_ID) )
*
( (Sum({$<__Pivot_Intervall_PeriodType ={'Intervall'}
, __Pivot_Intervall_Role={'EntreeSortie'}
, __Period_id = {'$(vdate_analyse)'}
,[__Status.FR] = {'(Actif)'},
[__Contract_Type]-={'IN','PS','TV','ST'}
>}
distinct(__FTE)))
So my question how i get the last occurence?
thank you in advance.
You need to filtered out the max date in set analysis, something like:
Count({$<your_dateField={"$(=max(your_dateField))"},.....,etc>} distinct(__FOLDER_ID) )