4.6.5 Sale Planning Model: DAT02 module

Patrykallaboutfood
Patrykallaboutfood
in Academy Discussions

In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters

  • For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data forward a year

Hello,

I am trying to create a formula with 3 LOOKUPs (time, account, product - using system modules) but for some reason I get an error message saying:

'Dimension of mapping used for lookup doesn't match any dimension of the result'

image.png

This is my SYS03 Account>Product Details, I used A1 Account line item as one of the lookups, as well as the P2 Product (however P2 product column is currently formatted as a list and I tried to populate it using the FINDITEM formula - without any success).
→ My final LOOKUP was the PY Qtr from SYS00 module).
Final formula: 'DAT05 Historic Revenue'.Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS03 Account>Product Details'.'P2 Product', LOOKUP: 'SYS00 Time Settings'.PY Qtr]

Dimensions of my modules:
DAT02 PY Revenue to CY: A1 Accounts, P2 Product, Time Range: Model Calendar
Historic revenue module: A1 Accounts, P2 Product, Time Range: FY19

I would be extremely helpful if someone could point me in the right direction!

image.png

Thanks!!

Happy New Year!

Tagged:

Answers

Categories