-
Can we have 2 DCA for one line item?
Scenario - At the UX level , a user will come and input a value in the line item(For example KPI). This KPI is different across different geographies. So a user can only edit KPI from his/her region. In order to do that I set DCA at the KPI level. Now once the user has put the value, manager will come to review and if all…
-
L1MB 13.6.3
After I completed the lesson my answer doesn't match the screenshot. My margin summary starts at Jul 21 when the screenshot starts at Jan 20. I used forecast periods as the filter. I went back to the REV03 module and I still can't find the issue. Can anyone help?
-
3.6.1.1 Roles
Hi, I am trying to create roles for Product Supply Manager. I am confused about Access Driver Modules : AD01 P3 --- Write AD02 -- Read Are these correct? Please help me. Mark
-
Forecast in foreign currency - do others do this?
We are beginning our initial Anaplan build now for forecast, and we're trying to determine the best way to dollarize our unit forecast in appropriate foreign currencies and then roll up to a USD forecast. We're working with a business partner to implement, but our internal IT team is questioning if this is core Anaplan…
-
Boolean issue in INV01
Hi, Boolean icons don't show in the two line items although they have Boolean formatted. No problem with the other two. Please see the screenshot and guide me. Thanks, Mark
-
Level Conclusion - Inventory Ordering Saved View and Export
Hi, So can anyone tell me how significant this is please - I've made the csv export here and it LOOKS the same as the comparison download, however on closer examination: 1. I have a number of Beginning Inventory figures in the year are different - is this of impact down the line? 2. Weirdly I have 7 products named slightly…
-
How to SUM using a dummy list
What is it? This article explains how to SUM, SUMIF, and use other aggregation methods using a dummy list rather than Anaplan’s native summary functionality. Why is it useful? Anaplan's native summary logic is simple to use, elegant, and effective. However, sometimes it results in bloated modules that use up workspace…
-
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.