In the columns of Query
calander year/month with selection mandatary variable
(formula)turover rate per month =NDIV0 ( ( 'IN (+)' - 'OUT (-)' )%A ' CLOSING MONTH')
This current formula does NOT meet the full requirements of MY CLIENT.
Based on the client requirements, I should have the following formula :
Hence, in the current formula, we miss the Opening Month.
Definition of the Closing Month.
o Number of Headcount at the end of the Month.
Definition of the Opening Month.
o Number of Headcount at the beginning of the Month.
 in other words, the OPENING MONTH value is exactly the CLOSING MONTH value of the preceeding month.
 Hence, we should be able to build a « Selection », same as the current Closing Month
-key figure with head count
-action type with not assigned
-employee status with active and inacive restrictions
But, with added by a complementary characteristics :
 0CAL/Year/MONTH, having a special variable with Offset -1.
This variable should take the value of the main variable over (from Calendar Month/Year) ;
calander year/month with selection mandatary.
And used it as value, that select the previous month, thanks to its offset 1 .
 please analyze this issue, and propose a solution for applying the cleintrequirement in the formula ?
thanks in advance.