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

hinamahmood1994

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

Data_01_102942.JPG

Data_02_102942.JPG

Accepted answers

hinamahmood1994

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 🙂

All comments

CommunityMember126793

@hinamahmood1994 your applied formula only looking for Account from mapping module (Account > Product) rather product..

I hope you want to map previous year data (FY19) to next year (FY20)..... believe your both the modules are dimensioned on same list (Account > Product) so you only need to LOOKUP on Time module..

Try removing the 1st LOOKUP from formula if my above guess is correct.. and see if u get the expected result

Misbah

@hinamahmood1994

Community is here to help but remember the intention of Level 3 is to test each individual on their Anaplan skills as well on their analytical capabilities. Please do not share the formula on Level 3 related issues. There are other means to help as much as we can. Before taking Level 3 we had taken virtual oath of not sharing any formulae or any questions related to L3 with anyone.

Cheers:)

ChrisAHeathcote

@hinamahmood1994

Ensure that the format of the line item which informs your LOOKUP is either a time period or list. The dimension of the line item in the mapping must also be the same as the dimension of the data source.

Often users will try and build a LOOKUP whereby the line item is a TEXT format. TEXT formatted line items have no relevance in a formula requiring a mapping function.

Good luck,

Chris

hinamahmood1994

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 🙂

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…