Formula Revenue by Sales Region

Options
Jasper
Jasper Member, ALL USERS Posts: 4 New Contributor
in Anaplan Community

When adding the formula for Revenue by Sales Region, I get an error message about the dimensions.

I have made a seperate module and I have used the formula:

Partner Revenue.Revenue[SUM:Partners.Sales Region] + Direct Revenue.Revenue[SUM:Employees.Sales Region].

What is blocking the formula?

 

Thanks,

Comments

  • Jasper
    Jasper Member, ALL USERS Posts: 4 New Contributor

    I try to use the formula using Parters list and Eployees list (columns Sales Region). Attached is the Blueprint of the Revenue by Sales Region. I can't work out what is causing the dimesion issue.

    Could you please advice.

     

    Thanks,

    Jasper

  • Jasper
    Jasper Member, ALL USERS Posts: 4 New Contributor
    The Employees list and Partners lists, both have the format set as "List, Sales Region". I would have thought this would enable to match.
  • Jasper
    Jasper Member, ALL USERS Posts: 4 New Contributor

    I have tried to change the Direct Revenue (Sales Rep instead of Sales Region), but did't accept. I have attached the blueprints and the error message.

    Hop this help to asses the issue.

     

    Thanks,

    Jasper

     

Categories