Best way to convert Annual assumption to Monthly metric

  • 7 September 2022
  • 1 reply

Userlevel 1
Badge +2
  • Budding Pigmenteer
  • 8 replies



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 7 September 2022, 08:58

View original

1 reply

Userlevel 6
Badge +11

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