-
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.
-
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?
-
Cell Count Calculation in a module
Hi All, How can we calculate cell count of a line item in a module?(Not sparsity/model size) I have a few questions with this: 1. Do we include parents in the count if the list is a hierarchical list? 2. Do we calculate no. of versions even if it is not present in dimension? 3. How do Time ranges affect the cell count of a…
-
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…
-
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…
-
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…
-
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…
-
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.
-
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
-
9.2.6
I got most of the formulas to convert and are fine but the unit price growth and unit cost growth are both giving me errors.
-
7.2.4
The formulas are giving me a strange error. Please help
-
7.2.2
I am getting errors when I am trying to put in the formulas. Check Photo
-
Create range based on input line item
Hi , Please help/advise on how I can create a condition where we can automatically calculate our rebate based on the uploaded volume. I created a separate list where i define the range and the corresponding rebate. In my calculation module, i need to lookup the rebate based on the volume that was uploaded. My problem is…
-
2.3.8.4 - % by week
Hi - how far off am I this being correct? 'DEM01 Volume Growth Rates'.Growth % * 12 / 52
-
7.2.1
I am getting an error message while trying to map the data.
-
7.2.3
I am a little confused on the mapping. It brings up time but I do not know how to get rid of time as a dimension.