Lookup on Parent elements

Options
moritz_knorr
moritz_knorr Member, ALL USERS, Community Pioneer Posts: 5 Master Anaplanner of the Year
in Planning & Modeling

ello anaplan Community, Hello anaplan Support, we stumbled upon a problem that seems to us like a functional error of anaplan. Example Setup: List "List_A":

  • A
  • B
  • C
  • D
  • E

List "List_B"

  • a
    • aa
    • bb
  • b
  • c
  • d
  • e

Module "Module_A" Lists: "List_A" Line-Items:

  • Value_B: Formula: B_Module.Value[LOOKUP: Lookup_B]
  • Lookup_B: Format: List_B

imageModule "Module_B" Lists: "List_B" Line-Items:

  • Value

imageProblem

  • I Want to push the values fetch the values from "Module_B" in "Module_A" using the Line-Item Item.
  • If i want to get a child element it works.
  • If i want a parent element it does not work and shows a zero.

This works: imageThis does not work: imageI already found a workaround for my problem. But it is a workaround and i try to avoid workarounds.

  • Why does my approach fail?
  • Is it an error in anaplan or is the functinality disabled on purpose?

Thank you very much in advance for an answer. See you on the next anaplan hub Moritz Knorr (AXA Germany)

Tagged:

Comments

  • moritz_knorr
    moritz_knorr Member, ALL USERS, Community Pioneer Posts: 5 Master Anaplanner of the Year
    Hi Kirsty,
    thank you, that you want to help! :)

    Here is a link to the whole post as a pdf, since the images are working on my smartphone and colleagues computer.
    https://moritzknorr.de/anaplan.pdf

    Cheers
  • moritz_knorr
    moritz_knorr Member, ALL USERS, Community Pioneer Posts: 5 Master Anaplanner of the Year
    Is anyone able to help me with this topic? 😞

Categories