Lookup in Anaplan but with different dimensions

Options
aatan
aatan Member, ALL USERS, Community Member Posts: 1 New Contributor
in Planning & Modeling

Hi Everyone,

 

I have 2 modules:
The first being 'Module - Calculate' with 2 dimensions: 'Site and Services' and Time. It has 2 line items, number of days and total cost.

The second 'Module - Rate Table' with 2 dimensions: 'Site' and 'Numbers'. It has 2 line items, number of days and Rate.

 

Reason for separating the Rate table is because the rate would apply to all services associated with the site. 

The 'Numbers' is just a list containing numbers 1,2,3,4,.... 99, 100. 

 

The formula I can't seem to get is how to the 'Module - Calculate's total cost. I need to multiply the number of days by the rate. i have made both module's 'number of days' format type list(Numbers). However when i enter the calculation as Module - Rate Table.Rate[Lookup:Module - Calculate.Rate], the error msg says: Level mismatch on common dimension. 

 

How can i get the Calculate module to lookup the Rates module when they have a different dimension?

Tagged:

Categories