How to do a month-over-month comparison with this formula in Fusion / OAC?

User_CAF6Z

Hello,

I'm trying to calculate the turnover rate and hires with the formula below in Fusion (or Oracle Analytics Cloud), and I would like to know how I can make a month-over-month comparison.

Here is the formula I’m using to calculate the hires/terminations:

MSUM(
FILTER(
COUNT(
DISTINCT
"HCM - Workforce Core"."Employment Information"."DW_FA_X_WORKER_NUMBER_WORKRELATIONSHIPPEOWORKERNUMBER"
)
USING "HCM - Workforce Core"."HR Action"."Action Name" IN (
'Colaborador - A Pedido Empregado Aposentado',
'Colaborador - A Pedido menor que 1 ano',
'Colaborador - A pedido',
'Colaborador - Com Justa Causa',
'Colaborador - Falecimento',
'Colaborador - Por acordo - ART. 484-A CLT',
'Colaborador - Rescisão Antecipada de Contrato',
'Colaborador - Revisão de Decisão Judicial',
'Colaborador - Sem Justa Causa',
'Colaborador - Término Contrato de Experiência',
'Término Contrato Prazo Determinado',
'Colaborador - Sem Justa Causa PDE',
'Colaborador - Falecimento',
'Colaborador - Por acordo - ART. 484-A CLT'
)
),
12
)
/
MAVG(
FILTER(
"HCM - Workforce Core"."Facts - Workforce Person Count"."Worker Count"
USING (
"HCM - Workforce Core"."Assignment Information"."Assignment Status" IN ('Ativo - Elegível para Folha de Pagamento')
AND "HCM - Workforce Core"."Business Unit"."Business Unit Name" = 'Vibra Energia S.A.'
AND "HCM - Workforce Core"."Employment Information"."User Person Type" IN ('Colaborador CLT', 'Diretor')
AND "HCM - Workforce Core"."Position"."Position Headcount" = 1
)
),
12
)

I would like to know how I can adapt this formula to compare month-over-month, that is, how I can calculate the difference between the current month and the previous month. I’ve tried using AGO and other options, but I couldn’t get the correct result.

Can anyone help me make this month-over-month comparison work correctly?

Thanks!