-
Aggregate Subset of Dimension
Hello, I'm trying to figure out the best way to aggregate a line item with two dimensions (SKU and Sales Channel) by Channel. For example, I would like all sales for a specific SKU for only website or Amazon channels. The issue I keep running into is my aggregation line item dimension should only be SKU to save on size,…
-
count wrt day timescale
Hello , I/p screen Products start date End DateA11/3/20205/3/2020A21/3/20208/5/2020 O/p Screen should contain the product count and it should look like 1-Mar2-Mar3-Mar4-MarNo of Products2221 Can we able to do this in anaplan?(As the output screen in Day time scale) Thanks Tejaswini
-
Datatype error?
Hello, I'm trying to get the desired output in (see below or view the attached image). So far what I've tried doesn't seem to work (datatype mismatch). Any ideas on how to solve this?
-
L1MB-5.2 model maps
Hi, I am facing problems in 5.2.2 model maps overview.I am unable to figure out how to do this step.Please help.
-
Level 2 Activity 1.4.3.2 Import Data & Add Formula
Hello everyone, I have a question concerning the task 1.4.3.2 in level 2 model building. Why do I have do add a formula to the code line item? I have already received the codes through the import (see picture attached - I didn't add a formula). Thank you in advance! Johanna
-
Modules/line items actually used for filtering
Dear Community, I have a few modules that were created specifically for filtering purposes, but after some time I can't remember whether they are really and still in use for filtering, therefore I don't dare to delete them during a model maintenance/clean-up process. I can see that those modules/line items are not used as…
-
Formulas - dimensions month vs years & collect
Hi, I have a module that shows line items in years and uses the collect() function. I now need this in months, so have made a copy of this module, changed dimensions to months and there's currently no figures showing. How do I fix this? Thanks in advance
-
Level 2 Sprint 3 INV02 Country Summary module
Am I getting the wrong end of the stick?
-
Circular reference caused by interest effects on profit and cash
I have an issue with a circular reference for a revolving cash facility (RCF) calculation, which effects interest and cash figures, which then determine what the RCF closing value should be. The transaction/calculation is circular in its nature rather than it being an anaplan specific circular reference. Basic summary of…
-
Roles List
Hi, looks as though the Roles List has changed from what was originally in the Datahub (or perhaps it's a different list). We are given an Employee Details file to upload in the Datahub Model and the roles do not match the Roles flat list in the Datahub. Assume we need to create a new Roles Flat list and codes in the…
-
Day Time Scale
Hi I want to show daily in my Model for (Monday, Tuesday, Wednesday, Thursday, and Friday). Example : My time scale should be like Mon 01 Jan ,Tue 02 Jan ...... Is this possible in Anaplan? Thanks Tejaswini
-
Correct Formula's for Confirm PO Delivery and Confirmed Purchase Order Receipt
HI. Please could you give me some guidance on the below? IF PO Submitted > 0 THEN POST(PO Submitted, Shipping Time Weeks) ELSE 0
-
Lists
Hi, I am creating a module where I want Assets rolling up into Products (I have set Parent of Assets as Products). It is currently just a regular list, but my question is, do I want a numbered list? What is best practice and when is it best to use numbered lists? I've tried ANapedia but I didn't find it very helpful.…
-
Highlight Dashboard
Hi Friends, I want to highlight the Dashboard and not the Module. As when I apply conditional formatting and edit rules, it updates Modules as well. How to achieve that? N.B.- I am referring to Classic Dashboard.
-
Dashboard features assistance
Hi Friends, I am having drop down in my main module (Pic-1). When I am publishing it to my dashboard, I am having dropdown (Pic-2). But I want my report as (Pic-3). Pic-1 Pic-2 Pic-3
-
How to override values in Module based on list members?
Dear community, I will have a module which contains three lists - time, product and territory. Amount is the currently only line item in the module.There is use case where I need to override source system data. My target is to set functionality that I can set zero value for certain products and it will automatically copy…
-
Year format calculation seems wrong
Hi, I came upon a strange outcome of a (very simple) calculation. For my model I need to know in which Year a certain calculation should give out put. (Current year, current year +1 etc.) So I tried to create a boolean which specifies in which year a certain period is. It however gave strange out come, as it seems to…
-
Is there any way to select or Update line item @ top level of page selector
Hey, I have got one requirement from my customer, users want to update Boolean line item or edit a line item at tope level of page selector dimension. Please see below example there are three dimensions: Country(Page selector), City & Products(Rows) and one Boolean line item: Select Product. If I select top level item(ALL)…
-
Rankcumulate not working for line 101
Hi, I have a Running Balance line item where I used RANKCUMULATE formula, everything is working fine but starting from line 101 the value is incorrect. From previous month, line 101 was working fine as well. Only for this month Mar 21, value is incorrect. What could be wrong? The formula is working fine ever since, only…
-
Number and Text in same field
Hi, Is it possible to have both numbers and text in the same field? e.g. see screenshot. I want everything below BBB rating to state "breach". Thanks in advance,
-
Workspace model oversize
Hi, I received an error msg regarding the workspace exceeding the size limit when I wanted to add more lists into “Applies to” as I added an additional context/page selector and needed to add up the figures with an additional criteria in the formula bar using the sum function Is there a way to resolve this issue? Kindly…
-
Assistance in problem solving
Hello Friends, I am not able to make out, exactly what are Ques-1 and Ques-2 referring to. It would be of great help, if you could please help me understand the business logic and what should I look up to?
-
How to calculate the difference for each month of the time period?
hi! I'm not good at English. I want to calculate the difference for each month of the time period. Is it possible to get the duration of a month when the format is a time period? Thank you. Image diagram
-
Ending Balance Roll Forward to the Current Period
Hello, I hope you are all doing well. I need some help on my calculation. Issue is, I need my ending balance of the prior period to be the beginning balance of the current period. The thing is, these movements (beginning +/- movements = ending balance) are all members of the same list. It just does not come forward. The…
-
Function analog vlookup excel
Hello and thank you all for your time and help. I have 2 lists: "Test List 1" and "Test List 2", where "Test list 2" is created based on "Test list 1" according to the following rules: For each item has a text property Formula RANK = RANK(1, ASCENDING, SEQUENTIAL, TRUE, Text property) Next, I filtered those items that have…
-
Planual
Do we have a downloadable or a pdf formatted file of the Planual? Thanks!
-
Rolling time period
Hi, How do I show the rolling 4 quarterly periods on the table? For example, it's currently showing Q1FY22,Q2FY22,Q3FY22,Q4FY22. Let say Q1 has ended, I would then like show the next 4 quarters, namely Q2FY22,Q3FY22,Q4FY22, Q1FY23
-
TIMESUM on period-formatted line item
Hi Everyone, I tried to use TIMESUM on a period-formatted line item and got the following error. Anaplan seems to be indicating that the formatting of both line items is a problem, but both line items are formatted the same (as the Anaplan message shows). Does anyone know why this might be happening? Additional details are…
-
INV01 Inventory Ordering, Confirmed PO delivery and Confirm Purchase order receipt NEW FUNCTION
hello Folks! i need a guidance the formula of Confirmed PO delivery and Confirm Purchase order receipt NEW FUNCTION line items here what i have used:Confirmed PO delivery: POST(PO Submitted, Final Shipping Time Weeks) Confirm Purchase order receipt: POST(Final Shipment Amount, Final Shipping Time Weeks)
-
Level 1 Model Building- Importing Data
Unsure on what to do here, there are no dates available to map to.
