Skip to main content
Solved

Best way to convert Annual assumption to Monthly metric

  • September 6, 2022
  • 1 reply
  • 159 views

Forum|alt.badge.img+1

Hi,

 

I plan for benefits at an annual level using a metric called “Benefits as % of salary” with dimensions year, subsidiary, and version. As an example, for FY22 I have manually entered 5% as my assumption. What is the best way to then convert the annual assumption 5% to a monthly metric? As in I want to show the actual benefits as % of Salary by month and then show 5% going forward when the version switches to forecast. My annual forecast may also change by year, so I cannot use [remove lastnonblank: year]

Best answer by Nathan

Hi Josh,

 

In your BeneiftCalc metric, which will be by month, you can do

Salary * ‘Benefits as % of salary’[by constant:Month.Year]

 

This is equivalent to a VLOOKUP, allocating the value of the year to each month of that year

1 reply

Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • Answer
  • September 7, 2022

Hi Josh,

 

In your BeneiftCalc metric, which will be by month, you can do

Salary * ‘Benefits as % of salary’[by constant:Month.Year]

 

This is equivalent to a VLOOKUP, allocating the value of the year to each month of that year