Last occurrence

[08748190]

Hello , 

Can you give me an example for the last occurence without user for the function max

for example :

This salary  work for 100 % full time and after 60% 

so i want to get of 60%, 

Thank you in advance

[JordyWegman]

Hi,

Can you give some data as an example? Your example makes it a bit hard to help..

Jordy

Climber

[08748190]

( sum (  {$<

   [__FTE]={">= max({<__Period_id = {'$(vdate_analyse)'}>}[__FTE])"},

   [__Contract_Type]-={'IN','PS','ST','TV'}

   >}  distinct [__FTE]) )

With :

FTE : full time percentage (100.00 or 60.00,...)

[Channa]

if not max try with RANK asc or DESC where Rank=1

[David551]

Can you give some data as an example? Your example makes it a bit hard to help..

[SergeyMak]

It's hard to suggest without seeing data and data model, but FirstSortedValue() might help

[08748190]

My data is presented as the following :

FTE : full time percentage (100.00 or 60.00, 50.00, 32.00 , 40.00, 60.00)

Contract Type : (CDD ,  CDI  ,  ..)

Folder id : (10005, 10006...)