Solved

Best way to convert Annual assumption to Monthly metric

  • 7 September 2022
  • 1 reply
  • 24 views

Badge +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]

icon

Best answer by Nathan 7 September 2022, 08:58

View original

1 reply

Userlevel 4
Badge +4

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

Reply