Skip to main content

Hello,

In the below metric I want to use Dec 24 FTE (128.65) as a reference value for the forecasted months based on the metrics CALC_FTE.
I used dSelect:Month-1] but it’s only working for the first projected month which is jan 25  but not for the forecasted months.
For example in february and other forecasted months we should have 128.65+24

Thanks for your help
 

 

Hey,

What you could do to do this would be to 

  • isolate the Dec 24 values (filter on Dec 24 and remove the month dimension using SELECT)
  • apply to all months (ADD)
  • filter on the forecast months (IF)

This could look like this:

IF('Is actual month ?', CALC_FTE, CALC_FTEESELECT: Month.'Dec 24']]ADD: Month]

 

Hope this helps!

Hi,

Thanks for your answer. 
I did not precise but the last month as a reference value is changing for each Version (dimension: budget 2024,reforecast 2024, budget 2025….)
Your formula is working well only if i have one version. 
How can I trick your formula so it works for all the versions ? 

Thanks

Hi @Cedric LJ ,

You could update your formula as follow :

IF('Is actual month ?', 
CALC_FTE, 
CALC_FTEEFILTER:Month = 'Last December Actual']]REMOVE:Month]]ADD:Month]
)

Where ‘Last December Actual’ is the following metric which (Data Type : Month and Dimension Version)

Month>ADD:Version]rFILTER:Month.'Month of Year' = 'Month of Year'."December" AND 'Is actual month?']nREMOVE LASTNONBLANK:Month]

Given the following assumptions for the last actual month :



Hope that solves your issue.

Reply


Ask your question here!

Terms & ConditionsCookie settings