Modeling

Line item style setting
Hello all, This might be an easy one: How should I change the line item style? I'm trying to make mine like below:
Level 2 Sprint 1 Activity 1.3.4
Hello guys, I'm having trouble completing activity 1.3.4. I think that I'm supposed to refer to SYS05 for the region code when importing the parent to SYS06. Below is the capture of my mapping. After running the import, the "Region" line item on SYS06 is still empty. Your tips would be much appreciated. Thank you
Mapping
I am facing problem with mapping. In sheet 20 jan month name, in grid view jan 20, so facing problem with time mappaing.
Finditem Fails to Detect Valid List Member
Hi Anaplan, I've come across something strange and wanted to ask if anyone has any ideas what is going on or if this is a bug. I am creating a List using a Saved View that contains a list of codes (text) to be added to a list. The import action is set to use code only, and the source codes are imported into both Name and…
Formula for a Module
Hello everyone! I'm having a problem, I need to populate this Boolean line item (circled with green) on this module with the data on the list subset. But I can't select the list subset in the formula bar. Thank you!
How to do month to date(MTD) calculation in a module
How to do month to date(MTD) calculation in a module
Centralized Identity Management (CIM) - Huge Step Forward
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 be able to add or remove users from the "Users" section of Models. * Workspace admins will only be able to assign Model…
Conditional Formatting issue
Hi, Can I ask for help on the conditional formatting part. I have an input template where once the user inputted more than a hundred percent the cells should turn red stating that this is the maximum percentage they can enter. I created a rule (see below) but it seems to be not working.See below Both row and column are…
Sorting
I want to sort a list which is pulled in a module in rows(Pivot). Whereas, When I try to apply sort it is sorting based on line items(i.e Amount) Is there a way to sort this list ?
Limitation on Input Values
Hi, I have a question which might be fairly simple to some of you. So I have this Input template where Users need to input values in terms of percentage. But the Users preferred to limit the amount to only 100%. See below so as you can see on the screen shot provided. under the column Percentage % I was able to input both…
1.5.6.1 Create Historic Volumes Module - Mapping Help
Hello - I am having trouble with mapping. I seem to have everything right except time. Can someone point me in the right direction?
Logic to Solve different companies mapping to SKU as input
Hello All, I'm trying to solve the below logic but unable to; need your help on the same; The below module applies to the list SKU. and maps to the company which is applicable based on the boolean. I have input data sales price by SKU and by month and by all the company Now, I would like to get the sales price by SKU by…
Invalid Formula: Line Item not recognized as Line Item or List Member Error
Hi everyone, I am working through a Territory Model project and came across a really weird issue and I was wondering if anyone else in the community has a reason for why the error message came up. In the calculation itself, I am using a lookup function to bring in data from a calculation module to a data module but for…
KTLO activities and innovations within Anaplan
Hi! I'm currently working on a KTLO project within Anaplan and we are looking for new ways to enhance the platform performance and drive more impact to our client. For example, we have come up with a model size tracking dashboard in order to do quality checks on how data gets uploaded every day. If we detect a huge…
Beginning Inventory is not fetching the data properly
please see the attached modules to match the formula i adopt
Hide/Move Model Map Button!
I think all model builders will know the frustration of trying to open the settings menu and misclicking the model map! It will often take minutes to load on large models, with no option to cancel the selection - in some instances it even crashes the browser! Please give us the opportunity to hide or move the button to…
Option to disable the model map
Description of the enhancement required: Please provide an option to disable the model map. An example of the enhancement: In the Settings tab, there would be a section for User Preferences, which would allow me to turn off the Model Map. How would it help the business process: I never use the Model Map, but it gets in the…
Move/Ability to disable model map
With the gear icon being so small and so close to the model map, it isn't uncommon to accidentally click on the model map. When this happens in some of our larger models it can lock up our model for a good amount of time while it loads. Having the icon in a different spot, or having the ability to disable the icon (as our…
Assign Action - Disable unassign
Assign Action dialog window allows end users to assign new elements, but also to remove already assigned elements. In some scenarios it is not desired, as modelers are no in control here (we cannot put any validation if an element can be removed / unassigned). The idea is to add a configuration option (Boolean) to allow…
Usage of Lookup on Users
As we all know, We are not able to use Users formatted line item in Lookup to get particular user data. Can we have option to do the lookup on user formatted line item? It will help us creating consolidated dashboards on what-if scenarios by user dimensions.
Filtering time intervals on the UX
Hi I'm trying to figure out how one filters time intervals on the New UX. Doesn't appear where one can select months in lieu of weeks or quarters for that matter. I may have to do that at the model level. Thing is how does one? Is the solution to create a Time by Weeks module in the model and have that linked to the module…
Indication in blue print if a Line Item is used as DCA
There should be a column in blue print view of a module like "Referenced By" highlighting modules where a line item is used as a DCA
New features for Bundling Actions.
Are there any new features recently released that can be helpful in streamlining various actions into a process other than the usual way a model builder does it?
Line Breaker-Anaplan
Hey guys, Trying to figure this, I am triggering a mail from the end user, the body of the mail picks up inputs from the end user which comes from text formatted line item, MY ISSUE IS when the user enters in the text field something like this: - " 1- Hi 2 - Hello 3 - Hey " I want the mail to pick it up exactly the same…
NPV and Amortisation
Hi Guys I am running into a problem using the NPV calculation and a subsequent amortization calculation. Please see attached: I used the NPV formula to calculate the NPV of a 12 month variable cash flows. This is equal to the opening balance of a liability. 213,473) When i develop an amortization schedule including…
Percent Growth Formula Logic
Hello, everyone, I'm trying to put together the formula to display the appropriate Unit Increase by & Total Unit Value outputs in the table above. The logic should go thus: The 2% growth for FY23 should use the 100 unit value from FY22 as its base. The formula would go thus: (2% of 100) The 5% growth for FY24 should use…
Daisy Chaining versus Avoiding Duplicate Formulas?
Hi All, I have a question about daisy chaining versus not repeating a formula. From what I understand, the engine will calculate the below module faster if I didn't reference Division and Deal Size in the Selected line item. Line itemSelectedDivisionDeal SizeFormula(ISBLANK(Division) OR FilterSelections.Division =…
Stuck on L1 Training 7.2.1
For some reason, I cannot get the import right. I'm finding the import settings not very clear. I've attached some images of what I am trying to do, but also included from the course what it is supposed to look like. Any help would be appreciated!
Level 2 Sprint 3
I'm not getting any errors at the time of export but can't see any data. Please help
Run multiple 'Delete Actions' at once
There should be an option to run multiple delete actions at once under the Actions tab. PROS: Time Save Faster execution (Extra space)

Modeling

Discussion List