Level 1 Model Building 9.2.5 Adding the two formulas

npd5
edited February 2023 in Academy Discussions

When I try to copy and paste the formulas it tells me that the “Dimension of mapping used for lookup doesn’t match any dimension of the result”

 

please help.

Answers

  • @npd5 

     

    Thats why copy pasting the formula is not a good option. Understand the formula.

    Your formula is Module Name. Line item Name and then list formated line item if you are using LOOKUP or SUM function. 

     

    Your error message says it all - The dimension of your Source module has to be the list formatted line item in your module or Sys module dimensioned by that list.

    If it doesnt help please post the screenshot of your module, will try to break it with specifics 

  • Someone found the mistake and pointed it out to me. Thank you for responding to my question.