Modeling

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…
Fp&A case study access
Hi, I am not able to access 299 FP&A case study. Please provide the access for the same. Thanks Nitin
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
Select Function using Versions
Hi, In version settings, I have 2 versions 1. Actual 2. Forecast but none of those versions are marked as True for Current (Refer screen-shot). I Created 2 Modules 1. Source Module 2. Target Module Source Module has Versions and Locations as a dimensions, Line Item - Source LI (Number) Target Module has Locations as a…
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,
App analysis
Hello Team, Recently I started analyzing on Sales forecasting app from app hub. I didn't understood the concept of vice president, Area Manager and District Manager. And also their target value is same in Quarterly Rep target module. Thanks & Regards Keerthi
Multiselect booleans - how the Hyperblock behaves?
Dear Community, I'm seeking for your assistance with the following topic. In the model I'm contributing to we do have a possiblity that allows turning off/on some features. It's done using simple boolean line item dimensioned by list of features (to keep it simple). Let's say it looks like that: FeatureBoolean…
Tracking historical data in a live model without making the model huge
Hi Community, I've built a model where end users input information and it calculates outputs. This tool will be completed by end users on a adhoc basis, some will use it weekly or monthly, while others will it once in a while. One of the outputs, shown below, is based on live information in the model: As we want to keep a…
Day time period format
We currently cannot have Daily as a Time Period format for a line item Use Case: Mapping from a fake daily timescale to Real time. Issue: Currently we have to use a date formatted line item and to map from a Fake Daily timescale in the format 1 Jan 2019 to a date requires a lot of text and string manipulation
Swtichover set to False driving Formula error
Hi team, I have a Line Item where the Formula Scope = All Versions & Use Switchover = True. When I turn the Switchover off I receive a 'Formula is invalid' error I have tried removing the formula, setting Switchover to False & return the formula by the same error ocurrs I cannot see why this error would be happening. My…
Territory Allocation Urgent
Certified Model Builder
Hello, I completed Anaplan Way Training and also both Level 1 and Level 2 Model Builder trainings. As Certified Model Builder is a step in Anaplan Training Path for Partners is there an additional certificate or badge for it? Regards, Jarek
Rounding function giving different result for similar numbers
I am using rounding function to convert 3 decimal places to 2, but the function is giving different results for similar numbers. Original NumberRound to 3Round to 2 P131.49496$31.495$31.50 P235.49528$35.495$35.49 This should be 35.50 Formula used for rounding to 3 - Round(n,3) Formula used for rounding to 2 -…
Limit on Importing using "Combination of Property"
#Gurus, I am aware that we should minimize the use of "Combination of property" and get a unique ID from the source itself. This case is an exception, where the client IT team has turned it off. Is there any limit on number of records that can be processed when we are importing using "Combination of property". Thanks Arun
New UI
Hi team, I cannot able to see Action Features in my NUX. but my colleagues have this feature. Could anyone please telll me whats the issue. Action Feature is not visible
Import current month data
I already have previous month data. Now I want to import only current month data. Please assist.
Transfer Employees
Hi, I was wondering how people handle transfers in their model. I saw a previous post that referred to a doc but I can't seem to find the doc. Any advice? Here is the previous post: https://community.anaplan.com/t5/Locked-Product-Requests-for/Transfer-Employee-Button/td-p/2821

Modeling

Discussion List