Convert hire date to number of FTE by month

[Zakaria_Bouacheria]

Hello Alteryx community :)

I'm trying to move a process from excel/power pivot to alteryx and i encounter a difficulty with a formula.

I need to convert each people hired (internal and external) to number of FTE by month, the final goal is the calculation of the payroll, for example :

Mr Jack.B is hired from 07 august 2023 to 15 december 2023, the expectation should be :

August 2023 : 0.8 FTE

September 2023 : 1 FTE

October 2023 : 1 FTE

November 2023 : 1 FTE

December 2023 : 0.5 FTE

Many thanks for your help :)

[ChrisTX]

Have you tried the Generate Rows tools?  You can use a function like DateTimeAdd to get rows for each month, from your start date to end date.  Then convert a date value to just a Month.

Posting sample input data will help.  And any workflow you have so far.

Chris