L1MB 9.2.5

rgarg25
rgarg25
in Academy Discussions

Hi Anaplanners,

 

I'm getting attached error while using formula to populate my module.

Can someone please help me.

Comments

  • MarkWarren
    MarkWarren
    The formula looks correct, but I would try pointing to the line items rather than typing, just to be sure the item names are correct. Apologies if you have tried this!
  • rgarg25
    rgarg25
    I've tried out pointing to the line items as well but still it's giving me an error.
  • MarkWarren
    MarkWarren
    Could you paste the formula you have?
    Here's my version for comparison:

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

    It has been solved. I just pivot the dimensions in SYS04 and SYS06 modules.

    Thanks

  • MarkWarren
    MarkWarren
    I should have asked to see the sources first!
    Excellent, well done for working through that, good luck with the rest!
  • jpazdernik
    jpazdernik

    Did you remove time from the SYSO4 module?

Categories