Skip to main content

Hi,
Do you have a best practice to recommend on how to manage interns who are converted to permanent contracts (=CDI in France) in Pigment?
Let’s take an example :
In my transaction list, I have Employee1 which is intern with an end date on Dec, 31st 2024. He comes back as a permanent contract starting January 1st 2025 (with no end date). 

In my FTE calculation metric, the term date metric is calculated with :
if(isnotblank('Employee Transactions'.'Term Date'aby last:'Employee Transactions'.'sPigment] Name','Employee Transactions'.'Load Month']),'Employee Transactions'.'Term Date' tby last:'Employee Transactions'.'sPigment] Name','Employee Transactions'.'Load Month'],previous(Month))

The last load concerning employee1 does not have a load date, as he is a permanent contract. However, as I have  “previous month” in my formula, it takes into account an end date. So my Employee1 is counted as 0 on January. 
Would you have some formulas to advise for this case ? 
Thanks
Venitia

Hi ​@venitiav ,

Instead of using the PREVIOUS function I would advice you to use a BY CONSTANT to always force the metric to use the data of the last load month available. Are you using the standard WFP app?
In that case you could find a metric that maps each employee to the last load available (EE_SPD_99) in this example. 

 

 


Reply