-
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…
-
New to Forum
Hey everyone! My name is Chad Pyke. I just started my Anaplan journey and am excited to learn from each of you! I'm hoping to transition into a career in Anaplan/EPM by EOY and would love any advice or counsel you have on the customer vs partner track. Thanks!
-
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…
-
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
-
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…
-
New to the Forum
Hi Community, I am new to this Forum. I started e-learning Model Building Journey last year and I am happy to be now Certified Model Builder (achieved last week). I am working as Project Owner Support and I am looking forward to increase my Anaplan knowledge and enhance my building skills.
-
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
-
How to Calculate Forecast period revenue in proportion of actual sales of CY
-
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…
-
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:…
-
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…
-
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).
-
hotw to obtain period of line item
Hello, I'm stuck on a formula that seems obvious to me. I would like to retrieve the time period of a line item : Week : list formated. time period by week : format time period, applies to week => i want to obtain time period for each week. Any idea? thx for your time !
-
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…
-
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.
-
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