Level3. Commission Forecast

Gharbali
Gharbali
in Modeling

Hello,

I have my total target per sales rep yearly as seen below and the numbers does match with ones in the study material:

Screenshot_16-11-2024_183120_us1a.app.anaplan.com.jpeg

In the Commission forecast I am using monthvalue formula to compute the commission forecast but the numbers are not showing up. Please advise:

Screenshot_16-11-2024_183911_us1a.app.anaplan.com.jpeg

P.S I have tried quartervalue also and it didn't work.

Thanks,

Answers

  • Prajjwal88
    Prajjwal88

    Hi @Gharbali ,
    As you have your source module dimensioned by year and target module dimensioned by month, you'll have to use YEARVALUE() function to bring the year values to months.
    Hope this helps.

Categories