
Modeling
Modeling
Discussion List
- HI. Please could you give me some guidance on the below? IF PO Submitted > 0 THEN POST(PO Submitted, Shipping Time Weeks) ELSE 0
- Would be great if a customer could choose how to format the months not just Jan 21 but P01 21 or P1 21 or P1 FY21. Now the period notation is only possible when selecting "13 4-week periods", but not …
- Some customers would like to have an Anaplan Platform feature to determine the resource utilization by a Model and Workspace from the Anaplan server-side: a tool that could show the specific amount of…
- 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? W…
- 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 Classi…
- 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 agai…
- 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
- 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 sy…
- 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 t…
- 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 dimensio…
- 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 a…
- 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 ex…
- 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,
- 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 f…
- 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 u…
- 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 diag…
- 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 throu…
- 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 h…
- 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, namel…
- 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…
- 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, e…
- 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, …
- Hi - I've been ploughing through sprint 2 and I have over looked most of the guidance for these formula - how close am I?
- 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…
- 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 …