-
IF and Then for ISACTUALVERSION and Forecast periods
Hello, I am working on Strategic Planning where I have actuals for 2019 and I am projecting for 2020, 2021, and 2022. I have a formula where I want to apply a 3% escalation starting in 2021. My current formula uses ISACTUALVERSION and Offset. Here is the formula: IF ISACTUALVERSION() THEN 'Actuals'.Period[SUM: 'Actuals'.AU…
-
New to AnaPlan
Hello Team , I am very very new to Anaplan, and I want to learn (Functionally & Technically) and want explore this tool. Please suggest topics and study material.
-
What do the bold & italics sentence mean?
Not available unless: You are a member of the Audience: Level 2 Model Building Completed
-
Archive selected modules in Anaplan
We needed to create a new hierarchy and **** the old one. We've been running two major modules alongside one another for a few months now. We want to archive the old hierarchy and all modules associated with it. Is there a way of archiving modules and lists but not the entire model itself? Thanks.
-
Model History Restore
Hi! Can the model history be restored after executing a delete using selection action deleting a bunch of items (around 50 million items) from a particular list? The model is in the standard offline mode. Thanks, Somain
-
Modeling
Hi Team, Below is my requirement, Could any one please help me? I need to publish the latest inserted list item to Dashboard. How to proceed? Thanks.
-
Selective push of line items through ALM
Hello fellow Anaplaners, I was wondering if it would be possible to selectively push line items/modules while synching models through ALM? The idea is - I would like to setup a master model and then migrate only the required functionalities/calculations to two different target models. With this setup, I will have to design…
-
Real to Fake Timescale
I am trying to map the Anaplan monthly timescale to a fake timescale that I have created. I have a location that has a date MM/DD/YY in which I am wanting to map that to my Month list that consists of Month 1 through Month 60. I am trying to do a formula that will map that date as the Month 1 list item and then each month…
-
Anaplan picking up double quotes instead of single quotes in a line item name
Hi all, Just wanted to check if anyone else is also facing this issue. off late if a line item name is having single quote (') in it, then if that line item gets referenced, Anaplan replaces that single quote (') with double quotes (") in the target place. I faced this issue while drafting a complex formula in notepad and…
-
Lookup data from two line items with different format and "applies to" lists.
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…
-
Need to use lookup or similar, dependent on two different flat lists
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 %…
-
Anaplan sales planning with AI
Anaplan yesterday announced that now platform has capability of AI predictions for sales planning I am not able to find any documentation or anything on platform does anyone have idea where to find it?
-
VARIANCE command
When we define an item we can set the number Format to Numeric and tag if an "Increase in Value" is Good/Bad/Neutral. Why do we not have a VARIANCE function to utilise that increase in value indicator? So if we have three different Versions ("Actual", "Budget" and "Actual vs Budget" and 1 item called "Sales" (with an…
-
Mac Versus PC - Different Browsers - What works and what doesn't on Anaplan?
Hi Community, I just wanted to create a post to allow users / model builders to share their experiences on the differences / issues they face when viewing a model / dashboard on a PC vs MAC and different browsers: It would be great if we could all share and then we can produce a list together of the known differences! So…
-
Copy last entered cell value to all
Hi, I am facing a problem, can someone solve it, please. I have a module which has Employee, Time Range(FY01 to FY15) as Dimensions Line Item - IP(List format), Growth % (Number Format) IP Line item is user input, by selecting a list item from a dropdown. Growth % - Value(Name(IP)) - Will change to number format. Let's…
-
Previous function in a if then statement
Hey there, I am trying to figure out the calc logic where the user has the ability to input a percentage in which will then be applied/reduce to the number. However i need a logic statement where the reduction is applied from previous quarter to next quarter. For example i have 100 in Q1Fy19 and then will have 99 in Q2…
-
Switchover workaround
Hello! I have a question on best practice with regards to version and switchover date... My model uses 3 separate data sources for Salary, Income and Other Costs, which are stored in 3 separate modules. Initially, I built the model assuming that each of my 3 data sources will be actualised to the same time point. At the…
-
Level 1: Create Saved Views for EMP02 module
Hi, I have moved on to the save dashboards section. I am trying to create the EMP02: Forecast Periods. The instructions ask to filter by forecast months only. However, it is not clear to me how I can filter based on that when I create a filter. The only time options in filter are about start date. I tried to set that to be…
-
Importing into a list based on a specific value of the parent
Hi, I'm trying to add functionality to a model where G3 items in a list are deleted and replaced with other items in that same list. The model has the following Hierarchy: In the G3 list, each Resource is either a resource in the current scenario or in the future scenario, this is achieved by the 'Type' property: On a…
-
Regarding Successful and Unsuccessful login
If we have a SSO model . We want to gather the details of Successful and Unsuccessful login for last 6 months. Is there a
-
Level 1 SYSO8 Errors ( but not for date, salary, or commission)
Hi, I receive an error message after I import Employee details into SYSO8. I got the dates, salary, and commission to work. However, it says other fields have errors. I want to ensure that I have done things right before proceeding. It did not give me an option to match dep code, country code, and Active?. Am I missing…
-
Linking formula
Hi, Please see details on the attachment. Regards,
-
Level 1 model building #E2 List Upload
Hi, I cannot seem to fix my employee list import. I keep getting the same error. If I select code, it will not let me import and if I select #name it will fail. The steps in a previously answered question were not clear. I also notice in my import source that display name property is missing even though I have it in my…
-
Certification Level 01 / Level 02
Hi everyone, I've recently passed both Level 01 and Level 02 trainings (Previously, I had 101 and 201). I did it online, is it enough to justify the official Model Builder certification? I received the 2 diplomas. Also, I plan to get the official Solution Architect but I have no clue on how to obtain it. I've been told…
-
Dynamic Cell Access (DCA) with subset
Hi Guys, I am trying to create a DCA access control module and noticed something . Wondering if someone can shed some light on this So i have a list and the list has a subset eg below I have 3 modules -First one "lets call it module" has above list as "Applies to" with 1 line item "Read" as Boolean and Formula as "True" .…
-
Day Count Convention (YEARFRAC)
Hi, has anyone found an alternative to Excel's YEARFRAC-Formula? The formula has various day count conventions such as Actual/Actual, US 30/360, Actual/360, etc. I am trying to get the year fraction for different time periods but it's quite complicated in Anaplan. Best, Evgenij
-
Re-ordering list item subsets in the list setting section
Hi Anaplan community, I believe I have just encountered an Anaplan bug but wanted to share if anyone has experience the same issue and whether it is a known bug. When creating a list item subset I have attempted to change the order of the list item subsets but even after changing the order and returning apply the list item…
-
Mapping Data Based on Combination of Codes/Number
Hi All, I would like to hear your idea or case regarding the topic. What needs to be build is to map the code based on combination of codes/number (please refer to the attached image that describe mapping logic table). I can create such logic but too much complicated to maintain(Use tons of IF, LEFT, and such). The table…
-
Difference between Top Level Item, Parent Hierarchy
Hi, I would like to know the difference between top level item and parent hierarchy. Is the top level item necessary when there is parent hierarchy?. Also, when would one use Parent in the list without having Parent Hierarchy and/or top level item? Would appreciate some clear egs. Thank you, Cheng Hong
-
Count with time dimension
Hi, I would like to ask something with regards to count with time dimension. The details are in the attachment. My apologies, i had to recreate the file since I was informed that I cannot post actual screenshot of data from client. Please see attachment for details. Regards,