Using a IF THEN ELSE formula and LOOKUP formula to solve a Customer Buying Group mapping question
Apologies for the late response to your message. I've had other organisational priorities over the past 5 months to attend to, but am now back working on Anaplan, in particular integrating our new Top-Down planning process into our main Anaplan FP&A model.
Many thanks for your response. I've read through it but am still unclear on how to incorporate some parts of it.
Please see the attached EXCEL file with the use case and Anaplan line item formula I am trying to write to achieve the desired outcome.