-
Formula help requested
Hi Friends, I am struck with a query. Need your assistance to proceed forward.
-
Model Calendar - Calendar type on Weeks, Module Time Scale - Day option
Hi The notes state that for Weeks calendar types, the available time scale are 'Week, Month, Quarter, Year' as per screen below. In a Weeks calendar types, when a module was created, the 'Day' was available for selection. Why is that so? I would have thought 'Day' should not be there based on the notes above or did I…
-
MBL2 Conclusion INV05 Formulae
Hi, I have spent a long time trying to figure out the formulas for the line items in the INV05 Shipping Export Module. For Shipping Costs - 'INV01 Inventory Ordering'.Final Shipping Costs and I know we need to also bring in the SKUs from one of SYS modules. However, I am unable to bring in the SKUs. Any help would be…
-
Computation with Price Escalation
Hi Guys, I would like to ask something regarding a formula I have been working on. See the table below. Price Escalation formula = Input Avg Selling Price = The Jan 13 value is constant referenced to 2.3 which is in another module. While the succeeding months starting Feb 13 to Mar 14 the formula is Avg Selling…
-
issue in anaplan level 2 training content. Help!
Guys I think there is a serious issue in the formula suggested for building "INV01 Inventory Ordering" module in this course. The requirement is to write a formula that would result in "Final Shipment Amount" to get reflected in the corresponding week as "delivered value" based on the "shipping time" of the "selected mode…
-
Improve a Numbered List
Improve a Numbered List
-
How to create an action to assign parent to item in system module
i have a flat list and want to create a system module having the flat item list and now i want to assign parent for that list item in the system module. How to create the action to assign parent.
-
Multi Scenario building
Hi.... I hope someone out there can provide some insight... I need to built something there I can recorded different scenario!! I already have a Scenario Version in my "Versions" however but I can only take one set of scenario "setting", I cant built anymore versions as every time I add a version it increase the size of…
-
Many to Many Dependent Dropdown
Hi, I have two lists, L3 - Plan and say Product Code. Now the Product Code dropdown line item in a module needs to be dependent on the plan line item. For this, I created a L3 - Plan formatted property in Product Code list to be used to drive the dependent dropdown. However, since it is a many to many mapping, a Product…
-
User Roles
Hello, I wish to create a dashboard where I could show the user - the roles of all the users and if they wish to change the user role they can update it from the dashboard, how can we do that? (I need an understanding how to display the user role of users on the dashboard) As deleting a user from a dashboard is not…
-
Excel pivot in Anaplan
Hi Anaplanners, i have a situation wherein i need to build a sub-report using a excel raw data file provided.The sub-report is just an excel pivot that needs to be replicated in Anaplan with the same functionality that excel has ,eg,Multiple select filters,multiple tabular view based on selection,sum values etc Can someone…
-
Sum by Parent
-
Module Structure
Hi - I have a hierarchy with two levels, say. Level 1(Parent) is Material Group and Level 2 is Material. In the material list, I have the code and the description(name). I need a dump from anaplan in excel or CSV in the format of "Material Code | Material Description(Name) | Material Group | <<Time Periods>> - each in a…
-
How to enable a boolean formatted line item when two submit button is true
how to enable a boolean formatted line item when two other boolean formatted line are true. also how to to freeze the two boolean formatted line itme once the enabled boolean line item is true.
-
Custom Disaggregation
Hi - I have a hierarchy with two levels - L1 and L2 (L1 is the parent of L2). The sales data is at L2 level. The forecasting is carried out at L1 level. The disaggregation logic for the forecasting line item from L2 to L1 should be based on the average proportions of L2 to L1 for the last three month sales. For example, we…
-
Unknown Error
What is this error? This error occured when I added "[SUM:XXXX][LOOKUP:YYYY]"
-
New solution architect Exam
I have completed my L1 and L2 certifcation exams and would like to know what are the next steps for getting certified as a solution architect. Thanks in Advance
-
Level 2 Sprint 3 Stock Exception REview Dashboard
hi when I click to select FY21 the table data still included months in FY20 see attached
-
Filter formular Monthvalue
hi, how do I construct a formula using monthvalue to be used as a filter ? thanks Donna
-
Cannot enter decimals starting with a dot via new UX forms
It seems that we cannot enter decimals without leading zeros (i.e .068) via forms. The field on the form is from a module with the same list and has the number format. When I open the module, I can enter the number as .068 in to the cell but cannot do it via the form because it is giving me an error saying "Not a valid…
-
mapping of property
Hi, I have created a list with members : A,B,C. This has a property with values 1,2,3 respectively which is also a list. Now in my list with 1,2,3 members, I need to map the values A,B,C (list) so that 1=A, 2=B, 3=C as shown in screenshot below : Is there a formula to automatically link the Property in List 123, to List…
-
MBL2: Conclusion INV05 Shipping Export
Hello! I would appreciate some help with the 'calculate shipping costs by location' formula in the INV05 Shipping Export -module. It seems like basic LOOKUP-function, but I can't get it right. The problem seems to be here the different time scales when I use values of DAT02 Shipping Metrics -module (month vs year) and time…
-
Big News! Anaplan Micro-lessons are available.
Big news Anaplanners! The Anaplan Academy has just published all their best practice micro-lessons from the level 1 to level 3 certifications. For me personally, the DISCO micro-lesson is one of the best. Congratulations @L.A.Foster and @ChrisMullen https://community.anaplan.com/t5/On-Demand-Courses/tkb-p/TrainingClasses
-
Normalization and De-normalization under the same hood
Anaplan is not just a one-stop solution to many essentials like user interface, data storage, data transformations, reporting, and most importantly the magic of modeling. "It is an elegant exhibition of synergizing totally different concepts into one common, consistent, and complete solution." Database management systems…
-
Enthralling thoughts about the trade of technology
* In how many businesses does making one copy or one million copies of your product cost about the same? * How many businesses have up to 99 percent gross profit margins for their product sales? * In how many businesses do many products companies eventually become services or hybrid companies (that is, providing some…
-
Referencing the Last Month of the Model Time Period For Comparison
In my model, I have the Current Fiscal Year set as "FY20: 1 Jan 2020 - 31 Dec 2020." As we move into future years this will be updated. I need to write a formula that pulls the last date of the current fiscal year; for this year it would be 12/31/2020 and when we update the Current Fiscal Year in 2021 it will be…
-
Invalid Selection, please select items from the '#Cost Center > General Sub Cat' list
I keep getting this error "Invalid Selection, please select items from the '#Cost Center > General Sub Cat' list" when trying to add a budget line under a COGS cost center.
-
Need help with NPV formula
Hi Everyone, I was applying discount percentage of 4% to a cash value of -193 , I feel that my value is incorrect please see attached screenshot. My formula is NPV(Cash flow input %, PCON). Could you please help me what I am doing wrong here. Regards, Manisha
-
Best practice - Accounts
1) Has anyone seen Accounts (e.g. P&L accounts) being defined as List instead of Line Items? 2) When these accounts are defined as List, how do you define the formula for accounts that require calculation, e.g. Profit? 3) Is a Dummy Line Item required? Can we do without Line Item?
-
Data Hub Download for Level 2 Model Building Sprint 1
Hi Anaplan Gurus, I working on Level 2 Model building Sprint 1 training. There is process step where Solution Architect asks for downloading Data Hub Model in your anaplan workspace. There is link provided in the activity to download the data hub for sprint 1. On clicking the link, System lands me on the Anaplan Frontdoor…