Skip to main content

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 nremove lastnonblank: year]

Hi Josh,

 

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

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

 

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


Reply