About CommunityMember117741

Hi, I have two modules (see pictures). The Attainment Employee Position Check module checks which positions an employee has during the current planning year and the Attainment Employee Active Position Check module will use the information used in the previous module. So in the example below an employee named TBH has the position Channel Manager 3 - Australia starting 2020-jan-01 and ending the postion 2020-feb-29. Based on this logic the Boolean in the other module should be TRUE for Jan and Feb, for Channel Manager 3 - Australia.  I am trying to build some logic [item('FL-Position') = First Position AND Start>= Fist Position Start Date AND End() <= First Position End Date), but, since both the employee list and position list used in these modules are flat lists i cannot use ITEM. Does anyone know a workaround this issue?    Kind regards         ... View more

Hi,    I need to retrieve information from a subsidiary view and use in logic in another Boolean formatted line item.    I want to see which account is unassigned during a given point in time. I already had a subsidiary this by month.  I needed to see it with a yearly time scale as well so I created the view below with time scale yearly.     What need help with is to add logic to my Boolean "Unassigned', to be TRUE for an account if the yearly subsidiary view is not blank for said account. The Boolean has no time scale (not applicable). In the example my Boolean should be TRUE for account 4703866. However, I cannot find a way to use the information in the subsidiary yearly view for my Boolean that will not have a time scale, and that is why I am hoping someone here can help me.    Kind regards.    ... View more

Hi,    I need to be able to display the page selector value in a column.    The purpose of the module is to assign multiple positions to an order. If it had been the other way around (assign an order to position) I could have used an "assign" action, but, now he task is to do it this way. I need the order column to display the order code (same code in all the cells) for the order that is selected in the page selector.  So in this case all cells in the order column should display 10973030.    Thanks for your help.    Kind regards,    Gabriel    ... View more

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