Hi, I'm stuck on a sum select formula ?? Circuit Pull.Project[SELECT:Projects.X, SUM: Circuit Pull.Range] ?? Essentially what I'm looking for is to hard code a specific project below, project 2 but I …
How can we link these EMP02 and REP04 modules to get total car costs by the region and role. When I am using formula i.e car costs = emp02 .carcosts[lookup: sys08.region, lookup.sys08.role] it is thr…
Hi, I need some assistance. I have created a dashboard in the NUX with 2 separate modules. I've created a Product Type Selector (Product Type A, B ...All Product Types) which then filters on the modul…
By the end of this month CIM will be rolled out - What does that mean for all of us? I personally feel this is a huge step forward as an additional security measure. * Workspace admins will no longer …
I have a line item that needs to reference one of the list items instead of a line item. What does this mean? I have a list of staffing types that use a model configuration to calculate based on what …
How close am i here??? The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role …
Hi, I have a reporting module that reports actual performance on 12mth, 3yr, 5yr basis. It is dimensioned by quarters and teams input information in relevant quarters e.g. Q4 2020, Q3 2020 How do I cr…
I have a module and it has three fields called A, B,C.. how to capture last updated date for those fields in anaplan. i know by clicking the history at the field level. but i want to capture via field…
I am importing the Locations flat list into SYS07. Everything is mapping correctly except for Region. I deleted and then re-imported the Locations flat file, but I still can't figure out why I am gett…
Got Struck at Q4 in Cert exam. This is my selection in SYS08 so I am expecting Department value I am passing to Emp02 Employee Expenses module Here medical cost showing 36800 that is showing as wrong…
Hi, I am trying to use standard users list with LOOKUP function, but i am getting an error "Invalid use of "Users" list with function 'LOOKUP'. I can see many posts in community says Anaplan looking i…
Dear Community, I have a case where I need to transform data based on product and customer information. The basic concept is that I have certain product # 1 and that value should be changed for certai…
Hello, I am stuck at step:2.3.9.2 Update Historic Volumes for Baseline Forecast I can't deduce the formula for "Offset Volumes for 1st Forecast Year" because I don't know the formula of "1st Forecast …
Hi , I'm trying to pull specific data based on the version selected by the user. I tried using Lookup and Select but didn't work. Any smart ways to fetch the specific values from the selected Version …
i have list with codes in a test module I am trying to replace last digits of code by +1 using substitute function but i am getting result- A1B1_1 ->A2B2_2 ----incorrect A1B1_2 ->A1B1_3 ------correct …