Skip to main content
Solved

Looking for a specific function

  • March 27, 2025
  • 2 replies
  • 53 views

Forum|alt.badge.img+3

Hello,

I’m looking for a specific function to make the calculation on this figure:

 

 

Can you please help me?

 

Regards,

Best answer by CDALMAY

Hi ​@Rockney_KPC ,

You can try the following :

METRIC_A[SELECT:MONTH-1] * Rates

Hope this helps,

2 replies

CDALMAY
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • Answer
  • March 27, 2025

Hi ​@Rockney_KPC ,

You can try the following :

METRIC_A[SELECT:MONTH-1] * Rates

Hope this helps,


Forum|alt.badge.img+3
  • Author
  • Author
  • March 28, 2025

Hello CDALMAY,

 

Thank you for your hep and I found the same solution yesterday but I used: [By sum: Month+1]*Churn_Rate.

 

Thank you again for your help.

 

Regards,

Rockney