## Dimension Mismatch

Frequent Contributor

## Dimension Mismatch

Hi,

Please see attachment for details.

Regards,

2 ACCEPTED SOLUTIONS

Accepted Solutions
Master Anaplanner/Community Boss

## Re: Dimension Mismatch

Hi,

do you know that you can put pictures in the post ? it would be easier for us !

When a target module references a source module and they don't have the same dimensions, you need to indicate to Anaplan how the target module can read from the source.

By default, Anaplan will try to sum, but that would not work if you don't have a top level on your dimension. Otherwise, you can use [LOOKUP:] to dynamically reference a specific element within the dimension, [SUM:] to sum values into a dimension following a property or [SELECT:] to select a specific element (to only use on the top level or an element that will NEVER change).

In your case, Anaplan can automatically sum the values of your rows, but you need to to indicate how to reference the Project and Dev Cost dimensions. You can do so using the formulas I explained above, depending on the logic you need.

I hope this helps.

Nathan Rudman, Anaplan Model Builder
Master Anaplanner/Community Boss

## Re: Dimension Mismatch

I would also take a look at this post recently.  There is a lot of good content explaining the differences and how to use SUM and LOOKUP

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Lookup-Sum-and-Textlist-Cheat-Sheet/m-...

David

2 REPLIES 2
Master Anaplanner/Community Boss

## Re: Dimension Mismatch

Hi,

do you know that you can put pictures in the post ? it would be easier for us !

When a target module references a source module and they don't have the same dimensions, you need to indicate to Anaplan how the target module can read from the source.

By default, Anaplan will try to sum, but that would not work if you don't have a top level on your dimension. Otherwise, you can use [LOOKUP:] to dynamically reference a specific element within the dimension, [SUM:] to sum values into a dimension following a property or [SELECT:] to select a specific element (to only use on the top level or an element that will NEVER change).

In your case, Anaplan can automatically sum the values of your rows, but you need to to indicate how to reference the Project and Dev Cost dimensions. You can do so using the formulas I explained above, depending on the logic you need.

I hope this helps.

Nathan Rudman, Anaplan Model Builder
Master Anaplanner/Community Boss

## Re: Dimension Mismatch

I would also take a look at this post recently.  There is a lot of good content explaining the differences and how to use SUM and LOOKUP

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Lookup-Sum-and-Textlist-Cheat-Sheet/m-...

David