-
Breakback for line items with Boolean format
As a model developer, I want to have option to set Breakback for Boolean input line items. This would be great especially for filters, using multi-level filters based on one Boolean line item can become easier. It should work if summary is set as "Any" or "All", and Breakback is ON for the line item, then clicking on…
-
DATA IN MONTHS AVERAGE OF 4 MONTHS REQUIRED
I have a query, that i am having data in months and count is the line item.how can i average 4 months of that data. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec FY22 120 123 140 145 150 60 70 80 86 78 79 80 ---- so Iam excepting output Average of 4 Months? Jan Feb Mar Apr ? ? ? ? And what format can i take for this of…
-
Best way to have a daily model in Anaplan
Hi, I'm creating a Daily model in Anaplan that needs to skip over weekends and Holidays. Instead of putting a formula in every LI. What would the best way to approach this? Should I be by creating a LI in the SYS's module that has this formula that will skip over weekends and Holidays and then call upon that formula? Or is…
-
Getting blanks after applying the correct formular
Hi Team, After applying the formular as required. My screenshot shows zero. Can you guide me as to what I am missing. screenshot below refers
-
Level 1 - Lesson 4.6.6
I am trying to correctly import and map the new data correctly, but I am always getting a an invalid name error when I import csv. May I get a quick explanation on what I may be doing wrong for a simple practice? I have previously posted about how the my training model seems a little different from the learning video's…
-
Drilldown highlights relevant logic string
When a user uses the drilldown feature it would be awesome if the platform highlighted the particular logic string that was being applied within the formula to determine the final result. This would be helpful to parse long, complex formulas with many possible results. For instance, sometimes formulas have many IF a THEN b…
-
3.2.11.3 Create Saved View for Combination Chart
Hi, I am trying to create Saved View (Chart for UX) but I am not sure the result is correct. It shows that Beginning Inventory is negative. Screenshot my INV01 : Screenshot of Chart for UX: Please guide me! Mark
-
Manual Entry
Hi all, Is there any possibility for manually entering and using formula in same line item... Knowing its not possible still is there any possibility for the same .... Regards, JEEVAK
-
Disaggregation
Hi Experts I want to Learn About Disaggregation can You Please Guide From Where I can Learn . Thanks In Advance .
-
How to link a property/line item on modules with different dimension
Hi, I need to get data from a line item from one module with a different dimension with my target module, I cannot do a lookup because the 2 dimensions are not totally related. See details below ; I need to get the Position value from the source to the target, as you can see in the target module, not all Position list is…
-
12 .4 .6 Level 1 activity Hierarchy level issue in Line items
After properly following and completing activity 12.4.6 Departments are coming together,and employees are coming together.But in screenshot of training employees are visible according to their departments.I have attached the document with message.Let me know where I am going to complete the activity
-
Simplifying a formula with multiple checks for User Input
Hi, I have a grid in which there are multiple line items (approx. 25). These line items are user inputs and when the user enters these either manually or through file upload, he sees a validation message that checks his input related to multiple conditions (e.g. Invalid Date, Mandatory Field Blank, Duplicate Entry etc.) .…
-
DYK - WEEK 9
WEEK 9: Start of Section Did You Know what “Start of Section” in Anaplan is used for? Let us understand it here. For example, there is a P&L module for all the countries, as you can see in the video. Now let’s say the requirement is to show the P&L values at an aggregated level (for all Countries) in the same module. Here…
-
Architecture and Modeling Mistakes: Deep Dive
In today’s post, we’re doing a deep dive on the Anaplan Live! session: Top 10 Anaplan Implementation Mistakes and How to Avoid Them. Focusing on the Architecture and Modeling section, we’ll review a few best practices discussed and illustrate how we can leverage them in our daily model-building activities. Why You Need a…
-
Calculate Cashflow on the basis of IRR set by the user
In Excel we have Goal Seek function to set Target value of a calculated cell and based on that target value, excel performs reverse calculations and gives source value needed to achieve the target. Now, in Anaplan I want to achieve this similar functionality. IRR is an Anaplan function resulting in value calculated from…
-
Is there a way to turn off the calculations done on Summary Methods in Snapshots?
Is there a way to turn off the calculations done on Summary Methods in Snapshots? Currently I am having an issue with the rollups on the snapshots because of the Summary Methods on the Snapshot module. For example: a line on a module has summary method of 'Formula' but the Snapshot has a method of 'SUM' so this is causing…
-
Formula and Ability to Edit
Hello, is it possible to have a formula that is formulated for a certain version or from an IF, but then allows you to hard code if that is not true? For example if we were to say "IF ISACTUALVERSION() THEN 0 ELSE {Ability to hardcode here}" Thanks in advance
-
Create product Replenishment Page
Hi, I am trying to create UX page for this. Time does not show as expected and also Shipping Method line do not show anything although my INV01 module looks good. Please guide me. Screenshot of my INV01: Regards, Mark
-
7.2.2 formula error
When I try to enter the formula for Product Family I am getting this error. If I change the format for Product Family to "P2 Products" the formula will work, but I am aware that activity 6 states to label the format for product family as "P1 product family". I do not know what I am doing wrong.
-
3.4.4 Activity: Create Stock Exceptions Review UX Page
As per instructions, UX page for stock exception review, time period are monthly , half yearly and yearly. Where my time drop down shows the weeks too. Is it not managed well till now? Regards
-
formula revision for QTR last year
Hi Community, I would like to ask advice on formula revision of my clients report. Below is the target module. The column of last year is where we are encountering a problem. Requirement: it is supposed to pick up the value from the source module but the total QTR of last year. Target module: OUT007 In the target module if…
-
Level 1 Exam Question 5
I did all the formulas correct for Bonus, Car, Medical but when it ask me total for Sales department for December 2020 and I entered XXXXXX for phone cost. It gives me incorrect answer. No sure were I went wrong. How do I trace back?
-
Level 1 Exam Activity 5
For last hour I am trying to figure out the formula and what I am doing wrong on Bonus formula. I am not sure if the formula is correct and 'Role' is not rolling up. Any help will be great. Thank you in advance.
-
3.3.12 Activity: Create Product Replenishment UX Page
A quick suggestion please , we have created a INV01 Inventory Ordering module and chart for UX as well but my quick feeling is none of them matches with view in terms of line items and sequencing of line items. We can simply ignore it ?
-
level 1 model building lesson 7.2.1
Any help here would be appreciated. I tried importing the product.csv into the product details module and it did not come out right. It looks like I'm missing something
-
Anaplan Level 1 Model Builder question 1
Hello, First question on Anaplan level 1 exam is 'what are the steps for building a model'. DISCO is not an option, some of the options were as follows: 1. Create User permissions and roles 2. Create Module 3. Create System dimension for Modules 4. Import Data 5. I do not remember 5th option. I revised the whole lesson 1…
-
10.2.6
seen this error , during putting formula in bonus , car costs, phone costs, medical costs
-
L1MB 9.2.6
GETING THIS ERROR WHEN FORMULATING THE UNIT COST GROWTH%.
-
6.8.6 Activity
Can you please help I got stuck in an activity (Level1 6.8.6) Please see the screenshots Expected Mine
-
Lists and Roll-ups in New Modeling Experience
I love the new Model Experience, but I miss the classic model experience in terms of viewing Lists and Modules on the same page. It would be great if we could add the Lists and Roll-ups functionality in the new Modeling Experience. As a model builder, we could see the Lists and Modules on the page together as we had in the…