Forum Discussion
JamesFR06
Resolver IV
Resolver IVHelp on holdays calculation
Hi, This is my table : Matricule Beg_Date Ending_Date Reason Type Abs Dab_Abs End_Abs Duration Dur_rk S21095 08/02/2022 08/02/2022 FORMATION Consentie 08/02/2022 10/02/2022 ...
JamesFR06 So, perhaps something like this, although this would not be 100% foolproof:
Dab_Abs Column = VAR __Matricule = [Matricule] VAR __Reason = [Reason] VAR __TypeAbs = [Type Abs] VAR __Table = FILTER( 'Table', [Matricule] = __Matricule && [Reason] = __Reason && [Type Abs] = __TypeAbs) VAR __Resut = MINX( __Table, [Beg_Date] ) RETURN __Result End_Abs Column = VAR __Matricule = [Matricule] VAR __Reason = [Reason] VAR __TypeAbs = [Type Abs] VAR __Table = FILTER( 'Table', [Matricule] = __Matricule && [Reason] = __Reason && [Type Abs] = __TypeAbs) VAR __Resut = MAXX( __Table, [Ending_Date] ) RETURN __Result Duration = ([End_Abs Column] - [Dab_Abs Column]) * 1. Dur_rk = IF( [Duration] < 5, "Less 5 days", "5 day or more" )
Greg_Deckler
Community Champion
Community ChampionJamesFR06 So, perhaps something like this, although this would not be 100% foolproof:
Dab_Abs Column =
VAR __Matricule = [Matricule]
VAR __Reason = [Reason]
VAR __TypeAbs = [Type Abs]
VAR __Table = FILTER( 'Table', [Matricule] = __Matricule && [Reason] = __Reason && [Type Abs] = __TypeAbs)
VAR __Resut = MINX( __Table, [Beg_Date] )
RETURN
__Result
End_Abs Column =
VAR __Matricule = [Matricule]
VAR __Reason = [Reason]
VAR __TypeAbs = [Type Abs]
VAR __Table = FILTER( 'Table', [Matricule] = __Matricule && [Reason] = __Reason && [Type Abs] = __TypeAbs)
VAR __Resut = MAXX( __Table, [Ending_Date] )
RETURN
__Result
Duration = ([End_Abs Column] - [Dab_Abs Column]) * 1.
Dur_rk = IF( [Duration] < 5, "Less 5 days", "5 day or more" )