About CommunityMember117741

Hi,  I am in need of some ideas, on how to solve a problem I am facing.  I have these 3 modules (picture below). The module OC Expected Renewals contains numbers. OC Expected Renewals already pulls in data from from the module 4f ACV Calculation, but, now I also need it to pull in target values from 5f Official Customer ACV into a new line item in the module (number formatted), call it target value.   Here in lies my current issue. OC Expected Renewals module has a customer list in rows and hand and another list in pages (see arrow), which we can call list A. List A contains 3 items; Blades, Products and Support. These three items are available in three different line items in the 5f Officials Customer ACV module. What I need to do is to pull the target figures from 5f Officials Customer ACV module into the OC Expected Renewals module with regards to each customer and which item is selected in pages from list A.        The OC Expected Renewals module applies to a different list than the 5f Officials Customer ACV module, but, the the 5f Officials Customer ACV module has a line item called customer which has the same list format as the module I will pull the data into. What I would want to do is a formula similar to eg. If 'List A'.Blades then 5f Official Customer ACV.Target value[lookup:5f Official Customer ACV.Customer] else blank.  The problem is that the line item target value adheres to the 5f module's list which is different from the line item customer (which has the same list as the target module, OC Expected Renewals.    In conclusion, I am trying to pull in a value from three different line items in a source module, and, which line item the formula pulls information from, to display, is dependent on which customer and which items in list A. But, the source and target line items have different formats and lists.    Kind regards,  ... View more

Hi,    My current build has been full of surprises. Right now I need to lookup start dates for new employees, but, the module I am building and the model from where I need to take the data, both use different lists. As you can imagine the lookup does not work and I cannot just pull data directly over without a formula. Do any of you have any tips on how I can work around this?    To explain more in detail.  I have a module, call it X, with a line item called "employee start date". This module has a flat list called "FL-Employees" (containing all the employee's names). The line item in module X shall draw its data from the line item "employee start date" (date formatted line item) in module Y. But, each date should be identified to an employee, thus, I need to do a formula similar to: Employee start date (in module X) = Employee start date (module Y) [lookup: employee name (also module Y). However, the line item "employee name" in module Y is formatted as a list (the same as module X, FL-employee) and lookup does not work.    Kind Regards,    Gabriel Ekman  ... View more

Hi,    I am quite new to the Anaplan Community. I have searched quite a bit, but, have not found an answer to the question I have, so I'll ask it and see if someone might be able to help me.    I am currently building a module where an employee should be able to see his/hers ramp % for both current and previous roles. The ramp % is tied to the role itself so in order to get the right ramp % I need to lookup the role with regards to the employee. My module contains the flat list with employees while the module with information about the positions uses the position flat list. Is there some way around this problem?    Thank you.  ... View more