Lookup formula Explained using lesson 9.2.5

Options
Jbrawley
Jbrawley Member, ALL USERS, Partner Posts: 5 Contributor
in Anaplan Community

So Jestena and I was trying a simpler way to explain the LOOKUP formula and came up with this:

We used activity 9.2.5 hopefully it will help grasp an understanding. 

Noelle, please let us know if this is not always accurate. 

 

Target=x[LOOKUP:y]

 

Target = is the place you will need to put your formula. 

x = What you are looking for i.e. Unit Price % (REV04 Price Growth Rates)

LOOKUP= is the link 

y = what dimensions are needed to make up x (reference x pivot chart)

 

In this case, there are two y's. 

 

REV04 Price Growth Rate Unit Price % (Dimensions) =

G2 Country (Dimension) which is located in SYS04 location = y1

P1 Product Family (Dimension) which is located in SYS06 Product detail =y2

 

So the formula would look like

'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

 

 

Categories