-
Level 2 DAT01 Inventory
I have imported data into DAT01 but the inventory amounts are not correct. I have attached my mappings but my issue is with the Distribution Centers. They aren't matching and when I check my data against the import, the values don't match correctly. I also added a filter to not show inventory that is 0. Thank you for your…
-
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…
-
Export action very slow in New UX
Hi All, I have published a couple of exports on the New UX. However, they take a lot of time in completing the export. There are times when it takes almost >30 seconds for a 3/4 MB export. The same export when run from within the model is much faster. Is this a New UX issue?
-
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…
-
Retrieve Anaplan Field from API? Cannot export in platform.
Is there a way to retrieve the following field via API or Transactional API? I noticed that there is no way to Export it via the Anaplan interface but am hoping there is a pathway to retreive it through Python or some other API tool.
-
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…
-
Selective Access in Child List formatted item
I am able to filter a list formatted item when selective access is enabled. However, it is not possible to do so when the line item is formatted as a list that does not has selective access enabled, even if it is a "child" of a selective access list. I need to be able to filter lower hierarchy levels based on inherited…
-
Ignore blank dates for MIN calculations
I'd like Anaplan to ignore blank dates when performing MIN calculations: MIN, x[MIN:y], and MIN as a summary function. For numbers, I can see why 0 is evaluated since sometimes those are true zeroes, but for dates this makes much less sense. With dates, I would want the MIN calculations to return blank only if all of the…
-
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.
-
Level 2 Sprint 2 - DEM03 Demand Forecast Module
Hi - I've been ploughing through sprint 2 and I have over looked most of the guidance for these formula - how close am I?
-
Display Dimension Properties along with Dimension
I am intending to display the properties of the dimension in a grid along with the dimension. If I add properties as line item then each line item is repeated across all the dimension elements, as the properties are tied to dimension members and they should not be repeating across dimensions. Below is the screen shot.. In…
-
Filtering non-numeric line items
Hello, I have read the below articles on how to filter line items using a Line Item Subset. This currently works great for my use case, except I also need to filter and include non-numeric line items like booleans. The below article runs into the limitation of only being able to filter numeric line items via Line Item…
-
2.3.11.3 Create Line Chart Saved View
Hi -I'm missing something really simple. How do I only show next 2 years?
-
Suggestions on Current User Filter Workaround solutions
Hey, I am using City list and Users Lists as a dimensions with few line items for one module and published that module on to UX page so that user can enter their information in line items. And i have made a saved view on module with filter on amount line item >0 (current user) and User list is on Page selector(but hidden…
-
LAG function
Hi, Question please. I am doing a variance analysis module which line items composed of Last Year (LY) Actual, Actual (current), Forecast, Budget and the variances line items. However, I am trying to have LAG function for the LY Actual line items. I am getting the numbers if I choose a specific month (e.g. Feb21) in the…
-
Level 2 - 2.3.91
Good Morning. Please could you give me some pointers? I'm not sure what this error means?
-
Fill line item with first list member
Hi , Is there a way I can fill up my line item with the first list member in the module ? Thanks in advance for helping. Regards, Tom
-
Time Dimensioned Data to No Time Dimension (Last Non Blank)
Hi Community, I am trying to take data that is dimensioned by two lists and time to a module that is only dimensioned by one of those lists and no time. Module 1: Dimensions: List 1, List 2, Time Line Item: Formatted as a month and calculates Start Date and has it show up for the month that it is in (ex: Feb 20 is start…