Formula retrieving not the full data

  • 26 October 2023
  • 4 replies

Userlevel 2
Badge +5


I have the below formula but my formula is only showing the clients for which the “Year of contract signature” is FY23 but is not displaying the contract signed in FY22,FY21… and cohort client type = “On Onboarding”)

Thanks for your help,


Best answer by Cedric LJ 27 October 2023, 17:53

View original

4 replies

Userlevel 6
Badge +12

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 ?

Userlevel 2
Badge +5


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


Userlevel 6
Badge +12

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

Userlevel 2
Badge +5

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