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
Page 1 / 1
Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.