-
Month Formula
Hi Friends, I have a list of Fruits and the month that is sold. Now someone has entered the month in TEXT format 1,2,3,..., 11,12. I want it to be Jan, Feb, Mar,...,Nov, Dec. Writing IF-ELSE is a tedious one. I was trying it in that way. Can you please highlight some easy way.
-
What is a Source Module?
Hi Friends, Please tell me, when do we need to build a Source Module?
-
New UX ability to extend the show/hide functionality to all selectors when creating a card
Hi Anaplan, I've been using the new UX and theres some functionality which would really improve the experience. Currently there is functionality to 'show and hide' items when creating a card but it only applies to the dimensions on the view and not all selectors. For example time and line items but not a geography…
-
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
-
Calculation
Thanks community friends for your kind help. I am stuck in a step. Need your suggestions. I don't want the percentage to add up but remain the same (ie 5%).
-
Calculation help
Dear Members, I need only these parent values. Which will be the easiest way to do it?
-
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…
-
Efficient way for handling large parent child hierarchies
Hi, I am looking for an efficient way to handle undetermined parent-child hierarchies coming from an ERP system. This is the challenge: I have about 35 local cost center hierarchies from different ERP systems, all with different number of levels, and extracted with parent-child-IDs. How can I bring this efficiently to…
-
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?
-
Numbered List - View
Hi Below are two numbered list screens. For Column 1, how does one toggle the view between system generated codes and Display Names?
-
IF function without ELSE condition
I am looking at a calculation where I want to have C = IF A > 0 THEN B ELSE DO NOTHING... DO NOTHING needs to retain previous value on C.
-
Dynamic module for list in a hierarchy
I need help creating a list for the market. I was able to do this at the retailer level, but how do you do the same thing for the market. I need to be able to do this so that I have the code for the market.
-
Resources every Anaplanner should be familiar with
Hi All, I recently thought about gathering the most important articles & resources that every Anaplanner should be familiar with. I was actually preparing it for myself, but decided to give it a go and share with everyone since it could be useful! Of course, all these materials are available at Anaplan Resources, but I…
-
Line breaks in free text fields
Please add the feature to enable line items and data with free text, with all characters including line feeds. Ctrl+Alt+Enter creates a line feed while entering the data, but it is lost when the data is referenced.
-
Dashboard filtering selection
Kindly let me know, is it possible to restrict view access by filtering.
-
Import between alternate hierarchies
Hi, I have the below hierarchies as follows Product Hierarchy: P1 Product P2 SKU Country Hierarchy: R1 Region R2 Country Alternate SKU Hierarchy: R1 Region R2 Country R3 SKU Both R3 SKU and P2 SKU are numbered lists. I have the below modules: Module 1 with dimensionality R3 SKU,Scenario and Time and a line item 'test'…
-
Page Anchors for Dashboards and New UX
My understanding is that there is no limit to how 'long' a dashboard / page can be, provided there is content to fill it. Page anchors and subsequently actions to navigate to them, similar to 'open dashboard', would be great (Including 'open' and 'navigate' behavior so that content is refreshed just like 'open dashboard').…
-
Selecting 'All Periods' does not display all Time periods
Description - Model has a timescale with 6 years and 'Total of All Periods' enabled - Open the dashboard 'Time only dashboard' - Synchronised rows is enabled for the grid 'Time only' (Time on rows) - Select 'All Periods' from the time page selector on the dashboard Expected result - The grid updates to show all time…
-
Level 1 Model Building
I'm not quite sure on how to change the summary for "headcount".
-
Level 1 Model Building
I'm currently taking the certification exam, and am wondering what to do when utterly stuck. I'm not looking for the correct answer just some assistance. My current question is how to to create a formula to pull data from another module. I've tried many different formulas including [LOOKUP:] but nothing seems to work.
-
Dashboard filtering selective access
Kindly suggest how to restrict the view access in the dashboard of unauthorised one.
-
Level 3 : Sprint 1 - TAR01 Detailed Sales Target (Names of Line Items)
Hi I have some doubts regarding the names of line items used in this module. Why this is important is because one can always judge from the name of the line item as to what should be calculated in the particular line item. Can I attach a screenshot of provided names and suggested names so as to get a better understanding…
-
Textlist on multiple dimensions
Hey Experts! Hope ya'll are doing well with everything happening around:) So there is this requirement where we require to bring in a list of selections into one single cell. My immediate thought was using a text list function (as i think that is the only way around it even though it has performance issues). Basically in…
-
Calculations based on text
Hi, I have an issue regarding how to set up a formula to get a calculation to work. I have a mapping module, where you can enter how a specific calculation should be done, looking like below: DriverComponent_1Calc_1Component_2Calc_2Component_3Revenues# units sold*average price per unitBLANKBLANK The format of the line…
-
Use Formula taking reference of a particular cell across any time period
Hi - Please help me how I can achieve the below expectation using a formula: * Say, I have 10 periods: 6 periods in past and 4 periods in future (i.e. the 7th period is the current period). * I calculate the mean of the first 6 periods (past periods) and store the same in the current period (say line item "Mean"). * Now, I…
-
Locking row item/s from deletion for select few roles on the basis of another boolean formatted line
Hi , I need help in the below query, I have a boolean formatted line item in source module published on a dashboard. As soon as the Boolean flag is marked “True” by ‘Role A or Role B’, the expectation is for corresponding row item/s to get locked from deletion for all roles except Role A & B on all the dashboards(two)…