Level 3 - Sprint 1 (4.6.5) - Lookup isn't working correctly

Options
hinamahmood1994
hinamahmood1994 Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Frequent Contributor
in Planning & Modeling

Hi, 

 

I'm a little stuck on Level 3 print 1 section 4.6.5. 

 

The formula I'm using looks correct but the lookup to accounts section isn't returning the correct values for me. 

 

'Data_01_ FY19_Sales_Revenue'.Actuals[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS00 Time Settings'.PY Qtr] This is the formula I'm using. The results I'm getting aren't correct. 

In my Data 02 Module, I get the Total Account Volumes against each product, instead of the product breakdown. 

 

I've attached both my Data 02 and my Data 01 Modules. 

 

Any help would be appreciated. 

 

Hina 

Tagged:

Comments

  • hinamahmood1994
    hinamahmood1994 Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 Frequent Contributor
    I managed to get it to work. I was missing a second look up clause to product, not just accounts.

    Thank you for all the suggestions 🙂

Categories