Modeling

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…
[SubscriptionHasClosedError]
Hi All, I often get the [SubscriptionHasClosedError] and a red diamond while editing the input cells. Any idea what does that mean? Attaching the error message for reference. Thanks
Creating a running sequence of numbers in Anaplan
Hi, Am wondering if there's a way to create a running sequence of numbers in Anaplan. Am trying to create a sequence of numbers that run from 1 to N in columns such that 1 is in col 1, 2 in col 2 ... N in col N. Reason am doing this is to see if there is a way to copy a certain cell value (say a number) from the left most…
Add Automated Line Item Reference if a Field is used in an Import/Export action
It would be extremely beneficial and time saving if you could add a reference to a line item that states if it is being used in any import or export action and what that action is. This would be similar to if a line item is used in another line item or module.
ANAPLAN level 1 , level 2 and ANAPLAN way
Could someone explain why a fee of $1500 is being charged when there is open course available as in the first attachment by the organization
How to enter the time in a line item?
hi! I want to make a module to know the elapsed time. But I don't know how to enter the time in the line item. Please let me know if there is a good way. I want to make it look like this.
9.2.5
The formulas are giving me a weird error message
10.2.6
I am having trouble with one formula and I am not sure how to fix.
Non-Production Data List Items References
It would be great if for Non-Production Data List Items, a model builder could see what references the list item. The only way to do this right now is to try to delete the list item and let the model roll-back so you can see where it is referenced.
Order List Action with administrator only
hi, I recommend user to Order List Actions. But, Users cannot do it. Does administrator only use Order List Actions?
As a builder, I need to implement more advanced workflows
Description: Would be great to add workflow functionality that includes * Submission and approval workflows * Trigger an event on an action or on approval * Use workflow status in formulas
Level 1 13.6.5 Show/Hide Function
I'm trying to build the custom view in activity 13.6.5, however I'm not understanding how to specify which line items to hide (I know to hide all, but Margin) and I know how to open the show/hide specification, but dont understand what I should be selecting in levels or specifying in items to get the view I'm looking for.…
User input by monthly and yearly
Hi, Do we have any work around for, User input for forecast version by months and budget versions by yearly, Below is the ss attached.
Level 3: Sprint 1 User story 1.3
Dear Team, In User Story 1.3 in Model Build Specification, it was asked to create a DAT05 model in the data hub. But DH Model does not have TR, Do we need to create a TR or I am missing something? @Misbah
calculate values from modules with different dimensions but with same ancestor list
Hi, This is my first post so I hope the example will be clear. I have a ‘Customer Hierarchy’ list and a ‘Product hierarchy’ list. Both lists have the same parent hierarchies (see print screen 1 below) Now I have a Sales module with the customer hierarchy as dimension and 2 line items (sales volume, product) The product…
6.10.2
When I try to add a formula to SYS07 it gives an error. check photo

Modeling

Discussion List