Hi Cedric,

hard to help you with the current information.

What’s the structure of this metric ?

What’s in the property Year of Contract signature ?

Hi Nathan,

Thanks for your answer.

“PRM company ID “ is a dimension and my list of clients.
Year is the year of signing of my contract.
Find below the property.

My formula is currently retrieve the “On onboarding” clients but only the contract signed in FY23 and not the other signed in FY22, FY21.
So i have only 33 contracts retrieve but it should be 80.
 

If needed here are the metrics 04.03  and CALC_OOBD

Can you try your formula in the playground without the BY and see if you get all contracts ?

I typically break down formulas like that

I have found the solution I did a by: ->