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?
... View more