-
nested Sum if
Hi, I need to get total of selected roles occurrence which can fall in three different categories. For example, among all the users , I need to count how many users have role of ADM, and then if they had the same role 3 months ago also- If yes it will be counted in No change list ( Category 1) and if their role is changed,…
-
Searching special character using "FIND"
Hi All, Just want to clarify if I can use FIND function to identify a special character. So I want to check if the string contain "@" ; the logic I am applying is: Line item 2 = FIND("@xxx.com", Line item1, 1) But it is not giving me the result. But works fine when I am setting the formula without "@". Line item 2 =…
-
TEXTLIST() for displaying values
Hello all, I've been wondering about a way to display selected values. To give an example, In my screenshot, three countries were selected and i like to display them to give users a sort of a recap. So i tought using textlist() as follow : However, it doesn't work and it seems that the problem resides in the fact that my…
-
Time Filter - Quarters and Year only (not half year)
Hi, I would like to only show quarters and the full year value (not half year values) for the current year. How do you create a time filter to only tick the quarters and year in the current year but not the half years. Thanks.
-
Anaplan Model Builders and Drummers
In Anaplan model building, we have to make sure that the four cornerstones (model, data, business process, and deployment) during every phase are addressed. All of them are equally crucial for the success of the project. I think that, in a way, model building is like drum playing. As drummers are able to move both arms and…
-
Native Version to Fake Version
Hey Champs, I was asked to provide a solution to one of the problems that one of our community member (@Naveed - not sure if this is your right handle) is facing. I couldn't arrive at the solution but was able to provide him the workaround. Let me know your thoughts on this He is using Native Versions in his planning model…
-
Count redundant word in a text line item
Hi Team, Is there a way to count a redundant words in a text line items? for example, I want to count the word "Anaplan" in a nested text line item that contains: "Anaplan is a cloud based tool. Anaplan can be very useful in planning reports". Is there a way to get a result "2" here. Appreciate your help. Thank you, Elaine
-
Forecasting
Hi, I have 48 months of historical data in my Personal Project and need to forecast for the next 12 months. I believe that Anaplan has AI feature. How can I achieve to forecast by using that feature in my model? Any ideas or examples? Thanks in advance, Mark
-
Landing page when you open a model
Hello Team , so when we open a model from the app page it lands on 'Time' tile in Model Settings. If we have a model role that has selective access, it generally opens onto a blank tile and then when they click on the module they have access to , they can see the data. Is there a way we can set what tile or module a user…
-
Best way to capture updates on line items and time of updates
Anaplanners, what would be the best way to capture updates to line items and the date in which line item is updated:- the ask is if line item is updated we have to capture the date on which it was updated. So one way I thought of is that if I can replicate the line items with copy line items, and then an action to paste…
-
How to Calculate Forecast period revenue in proportion of actual sales of CY
-
Dynamic calculation on Weeks vs Cumulatebyweek
Hello all, I have a tricky point, and cannot succed to solve it. There is Confirmed orders (already sold) and Forecast orders (we produce in advance because we think we need to have some stock for many reason). My company will produced all the quantities, but not exactly at the correct weeks (sometimes late, sometimes in…
-
Summary Value - Top level not defined in list
Hi, I have requirement in which I need the Total Cash value - which is kind of top level but the top level is not defined in the list configuration so I have tried my best to get the Total cash value for the "Sweep In" checks but unable to get the value without using the select statement as I have to make this list as…
-
Multiple UOM
Hi, For a client we have a setup where we need to plan and report on multiple UOM (liters and units). Currently we're looking into setting this up as following: * Client needs to decide per SKU on a 'planning' UOM. A UOM where all planning for that SKU will be done (inputs, overrides,...) * Create two Anaplan versions:…
-
Percentage Calculation
Hi All, I am facing an issue in the calculation of percentages at summary level.I have a module where I have a percentage calculation field where the percentages are calculated and are imported to another line item from there in the same module. As the second line item displays the option of user inputting the value under…
-
Forecast to get value from Actual version
Hi All, I am facing a challenge while replicating the Actual selection to Forecast. Can we have a formula where forecast will take the same Boolean selection as actual. In the Column are versions(Not list).
-
Previous quarter values
I have the following line items- A,B,C. I need to create a new line item D which should take previous quarter values if C=0. PFA screenshot.
-
Learning style
Hi All! I'm trying to get a pulse on the communities best note taking tool for learning Anaplan, both during certification path and after. I'd like to find a digital(and analog) tool where I can put my learnings and go back to to refresh and learn more. As this is a knowledge industry maybe even a STEM maybe there are some…
-
Invoice amount multiplied by six
Hello Team, 1. We have a model where all the invoice amount is multiplied by six after the latest data is uploaded. 2. Also, I am not sure where the source data is coming from, which I need help with as well. 3. Middle of all this our administrator left as well, so any help link, tips, or material will be appreciated. Any…
-
Filtering Data
Hello Community, In My model building I need a filter. Where if I Check on Monthly data should be available on monthly Basis. And if I check quarterly then it should be available in Quarterly basis so on.. Please help me through this. Regards JEEVAK
-
Last quarter of FY
Hi I'm trying to get the last quarter of the FY formula. I have Q1FY22, Q2FY22, Q3FY22, Q4FY22. I need a boolean which checks the last quarter of the FY ie., Q4FY22. Please help.
-
Movingsum function
I am not getting last 2 line of this table .how it is done
-
Sequence of Production Schedule based on Priority and Line capacity
We would like to seek assistance on how we can build a requirement where Anaplan needs to recommend the sequence and volume of products to produce in a line with consideration of line capacity and priority. Example: Data: Line 1 Capacity = 100,000 Products produced in Line 1 Priority Weekly Volume Product A 1 10,000…
-
Statistical Forecasting Discount Factor
Greetings! One of the models in use by my company is the statistical forecasting model, whereby material history comes in through a calculations module and the material is assigned a forecasting method based on the data there. Leadership has requested a change to how the history is weighted that they have referred to as…
-
Finding text substring in a List
Hello All, I have a requirement where my end users are doing some manual text based tagging(excel screenshot below). Within Anaplan, I maintained this mapping as a list with the tagged value as a property. I tried using FIND/FINDITEM of the substring within the Memo TL text line item, but in vain. Can someone help me with…
-
7 Benefits of Anaplan Modeling
Hi Model Contributors, I just read a really interesting Community blog post by @AntonS where he outlined seven benefits of model building within the Anaplan platform (spoilers: #5 covers the benefit of using standard Time and Versions compared to custom alternatives). I thought this would be a useful review for less active…
-
Aggregation Functions Other Than SUM
There are several types of functions in Anaplan: aggregation, numeric, financial, time and date, logical, text, call center planning, and miscellaneous functions. As a model contributor, you are probably already aware of the SUM function in Anaplan, which is an aggregation function, but how many other aggregation functions…
-
Graphs-Number Scaling
Anaplanners, Is there we can control the number scaling on the graph axis ? When i fix the graph size to say 1000-2000 it comes in 1000 format, while if the graph size is left dynamic or fixed for a higher range like 1000-10000 it automatically scales to 1k-10k. Is there a way i can control this and have it done as per…
-
Rename time dimension with YTD still available
I need to rename the months in the time dimension, but also need to have a YTD item too. I see there's an Idea submitted to enable renaming, however that has not been done at time of writing. I understand to work around this limitation I can create a custom Time list with the desired display names and a lookup module to go…
-
Converting data
Hello everyone, Is there any possibility of converting line item formatted as period (Month) into the TEXT? Thank you