102 Certification Project - Revenue Formula

Options
yasiri
yasiri Member, ALL USERS, Partner Posts: 5 Occasional Contributor

I have been trying to formulate the calculation for Revenue using SUM formula as follows. Could never get it right somehow. Can anyone suggest what I should look at again?

 

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


Cheers!

Comments

  • yasiri
    yasiri Member, ALL USERS, Partner Posts: 5 Occasional Contributor

    Dear Fuvas,

     

    There is actually no error but the numbers do not match. My forecasted revenue has the result of actual revenua according to the options provided by the course.

     

    Yasiri

  • Jenn.Cusmano
    Jenn.Cusmano Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor

    Hi! I am having the same issue. Were you able to figure out the right equation?

     

    Thanks!!

  • halltristanj
    halltristanj Member, ALL USERS, Community Member Posts: 2 New Contributor
    wrote:

    Dear Fuvas,

     

    There is actually no error but the numbers do not match. My forecasted revenue has the result of actual revenua according to the options provided by the course.

     

    Yasiri


    Same. Check the Forecast values.