-
Level 2 - 1.6.3.2 Import Data into DAT04 Distribution Center Parameters Module
L2 - Sprint 1 - 1.6.3.2 Import Data into DAT04 Distribution Center Parameters Module * Download data file: Weekly Safety Stock.csv. * Import data file into the DAT04 Distribution Center Parameters module. I am trying to do the mapping Distribution tab map is not coming properly Please help to resolve the issue . Regards,…
-
How Define the current time period for system
Hi Guys, How to define the current time period for system with out using Current Period & Switch Over, isactualversion & Iscurrentversions. is there any possible way to get with formula. BY this formula, system should find the actual period and Forecast
-
CAN Property become list
can any let me know, can the property become subset of a list
-
Put total in a line item
Good afternoon, I would like to place the total value of line item '%' in line item 'A'. In other words, I would like the amount 17,259 to appear in all the fields, but I haven't been able to do it. Could you tell me the formula to achieve it?
-
combine two line items
I have two line items that are addressed to the same list but each one stores a value. that is, in lineitem1 there are some countries in lineitem2 there are countries that do not appear in lineitem1. I need to combine lineitem1 and lineitem 2 into lineitem3. How can this be done?
-
6.11.2
I am having a problem with inserting the formula. In level 1 lesson 6.11.2 You have to put formulas in for actual, budget, and forecast. the formula for actual and forecast worked fine. but when I put in the code for the budget it does not work. See photo
-
actual and forecast
Hi there, Anyone please help with the formula, Here i have actual value in one line item based on that the override line item should be editable. where jan22- apr-22 is actual values, show that override line item should be editable from may 22 Please suggest
-
2.4.7 Activity: Create Saved Views for UX
I'm lost at conditional formatting to only show the highlighted items in the example. Is there another formula I should be using in a module or this same module? How do I get the conditional formatting box to allow me to select "SF Bay..."?
-
What I can do to make sure I get accepted to the Anaplan Model Building Course?
Hi everyone, I have registered for the Anaplan Model Building Course. How long before they contact me and inform me if my application is accepted? I really want to get this course and am eager to learn about it. Is there anything I can do to make sure I get accepted? Thank you, everyone!
-
Fake Time to Real Time Calculation
Dear All, I have one use case where I have created one template for input the data. For this I used fake time dimension because the data will enter at monthly level in Year 1 and for future it's on yearly. Screenshot one shows the template which used to enter. But I am stuck between creating summary report. Because for…
-
Multiplication and adding two different line items
Class 1 is starting from 7 mar and class 2 is from 21 mar Now i need to write formula in Total For example in 21 mar Column, 62 * 2 (which is week 3 * prod ) and 80 * 2 (which is Actual Start - Day 1 * Prod (Next Wave)) (62*2)+(80*2) = 284 ----- the formula in Total is not correct now I try averaging the Prod and Prod Next…
-
How to get a first value of line item
Hi, I have requirement where I need to identify the first value of Borrowing line item and that value would flow into initial commitment. So I have used ISFIRSTOCCURENCE with a logic IF Borrowing <> 0 THEN ISFIRSTOCCURRENCE(Borrowing, Revolver Facility) ELSE FALSE but this will giving me two occurrence. what I need is the…
-
I want to get the first month of a period set in module calender.
hi! I want to automatically display the first month of a calendar set in a module that has not been applied to. Can ido it? Please help!
-
Actual vs Plan Reporting Issue (Different grains = double-counts)
Hi All, I have the following 3 Modules: Module 1 - Staging (Actuals) Lists - Supplier, Service Category, Time, Line Items (Amount) Module 2 - Input Plan Data Lists - Supplier, Service Category, Maintenance Category, Time, Line Items (Amount), Versions Module 3 - Reporting Module Lists - Supplier, Service Category,…
-
Why unable to pull the app?
Hi Community, can anyone help to understand the reason behind this error? Post login received the below error (tried more than once).. Is this app no more valid? If so then is there any substitute of this app in hub?
-
Dimensions: Time (Year)
How to change the Time to years
-
Registration for April Elevate Program?
Hi y'all, Does anyone know when the registration for the April Anaplan Elevate program will open? I want to make sure I don't accidentally miss it. Regards, Joshua
-
Disaggregation
Hi Community We are disaggregating data from L1 to L2 based on the past data. As a part of it we are getting decimal data in the L2s. We tried Round Off, But It is not matching the data of L1, due to round off. Is there any way to get the data in whole numbers, without losing the data. Thanks Badam
-
How to get previous value of line item which doesn't have time dimension
Hi, I have a use case where I'm using the custom time dimension list in which there is a line item called Beginning balance which is the previous value of the Ending Balance. So I'm stuck as there is not native time dimension being used in the module so I can't use previous function of Anaplan. Any work around is possible?…
-
Level 3 4.6.5 Sale Planning Model: DAT02 module
For the "4.6.5 Sale Planning Model: DAT02 module" step under Level 3, the data of Previous year is in a module having account flat and product flat. however, it needs to be imported in DAT02 PY Revenue to CY module, which will have A2 Account>Product# list which is a numbered list. Any clue on how to do move data between…
-
Total Count for number of items based on parent and type
Hi I am having an accounts lists (A1,A2...A5,B1,B2...B5) with Parent(Accounts) as A,B and parent(parent(Accounts)) as X. Type of accounts are Type A, Type B. If user(A,B,X) selects an account then the number of accounts under the particular user with same type should be display in target. For example, if User A selects an…
-
Survey Invitation: BPM Pulse Research
From time to time, and as you well know, the analyst community will approach us for customer insights to inform industry-specific research. Today, we'd like to point you, our trusted power users, to the 2022 BPM Pulse survey. Your input will help to influence BPM Partners' annual Vendor Landscape Matrix for business…
-
Propose to add Formula AutoComplete function
It would be great if Anaplan can have the Formula AutoComplete function just like what the Excel formula bar, so that user doesn't need to memorize all the formulas and general lists.
-
Avoiding a large intermediary module
I have a list of transaction codes that a user wants to summarize in a report that replicates what they've produced in excel. The transaction codes don't form a natural hierarchy for this. The excel report pulls out various individual codes, groups some together, summarises others etc. To achieve this I've got a line item…
-
How to get first date of the model
Hi, Does anyone knows how to get the first date of the model? *The first date that comes from the time dimension I want to compare the first date of the model against date input by user.
-
Level 2 1.3.6.3 Create Build Location Saved View and 1.3.10.4 Check Your Work
Can anyone explain why I'm not getting the view as displayed in the instructions? My screenshots show my saved view, the view after the import, and what it should look like. Thanks!
-
Need to know why getting Circular Reference
Hi, I'm adding my "Inta Month Growth" LI to the formula I have in the "Less:Ineligibles" LI and getting a circular reference. I can not seem to find the root cause of the circular reference. Please advise. Thank you LI "intra Month Growth" Formula LI "Less Ineligibles" Formula The Circular Reference I receive when adding…
-
% Percentage
Hi Team, Wanted to confirm if the below screenshot is correct? In my module, calculations are working but why is it coming as 105% in the screenshot - Check your build Thanks
-
10.2.4 Activity: Import Data into Employee Drivers Module
Hii after mapping successfully, Bonus % showing 0 value
-
How to calculate the YoY growth in line item
I have Year wise numbers in my line item in a module, now i want to calculate the Year by year growth in between years. I want to calculate FY21 YoY = FY21 Productivity growth / Fy20 Productivity Growth. FY21 YoY= 2.55% Please suggest me how get the result.