-
Scenario for calculation
Is there any formula instead of first occurance
-
Filtered Summary View based on the presence of a list member
Hello, I'm stuck on the logic to create a filtered summary view. I have a table A, but now want to create a filtered table B (which is a list of only the cost centers & Worker Type combination with a Large Group Size (i.e. Headcount total of 21 & above across all Work Groups.) So in the image below: The summary view (table…
-
Identify records with same value in Column 1 but different value in Column 2
Hi Team I need to identify records that have same value in Column 1 but different values in Column 2. For eg, from the below data set, I want to identify the 1st 2 records may be by adding another line item NameCodeTimelineRoger F1MonthRoger Federer1QuarterRafael N2MonthRafael Nadal2Month Thanks
-
Confused about Lag, Lead, Post, Offset
I got confused between these functions. It's unclear for me now. If any one can help me with simplifying this it would be very helpful for me. Is there use cases where Lag and Lead should be used instead of offset or post? Thanks in advance.
-
Rep Count from Start date to End date (if applicable)
Hi All, We currently have a "Positions" module that is not time based. We show our current salaries, job titles, etc. that comes from our payroll data here. This "Positions" module also contains the Employee Start Date & the Termination Date (if applicable). I have created a line item that counts the amount of "Job Titles…
-
Problem aggregating values from timscale day to month
Hi all, I have problems aggregating values from a module dimensioned with day, to a module dimensioned with month. I am doing rent calculations in a module by DAY time scale. When I try to aggregate this to a monthly calc module it does not work. No values are pulled over. It is the last part of the formula below that does…
-
Date Stamping the last time a Process was ran
Hello, I am aware that Anaplan does not have a Date Stamp ability and I have solutioned that; however, I am not sure how to apply a date stamp to the last time I ran a Process from the dashboard (e.g. If I run an Import today it should be stamped as 09/30/2022, or the last time it ran successfully). To do this, I was…
-
Cycle Shift Input Design
Hi Everyone, I am trying to design a module for shift input. It should be working in this way. When we enter shift start time and cycle period, that start time will repeat according to cycle period until we override it. I am struggling to design and figure out formulas? Any idea and tips are appreciated. Thank you.
-
Hello All. New to this forum, go easy on me...
Hi all. New here but not new to Anaplan. I've been here nearly 9 years. I'm joining this forum to help out and spread knowledge. Will help create some content and articles - any suggestions, what do you need here as model contributors? Let me know what you need and what you want to see... Post your questions, there are no…
-
ETL - Summary for hierarchy
Hello! I am trying to build an ETL that will upload into a client's ERP system. They have some nuanced requirements, and I'm struggling to build one of those into our module. In the image below, I need to have the parent values displayed for the highlighted columns: This module uses L2 for account numbers, and the parent…
-
RANK on Total & Sort Nested Dimension
Hey builders, I'm trying to match a mockup, but having trouble building it in Anaplan. User Story: I need to rank all projects by their total cost (highest to lowest) while showing the breakdown of Project Total Cost by each Cost Pool (if there is a value in a cost pool). Rows: Projects and Cost Pool Columns: Cost My…
-
Convert list item to time period
We make a weekly copy of the demand plan to be able to calculate bias and forecast accuracy with 2 weeks lag. In a list we created versions : The last Property "Reporting Week" is formatted as Time Period "Week" The data is copied in a module with this list and the product list on the lowest level as dimensions : How can I…
-
Optimizing Models, blueprint Analysis
Hi all, I am beginning my journey as a model builder in a company where one of the first task is to try to optimize the current Anaplan Models, I've followed the instructions given here to try to reduce the cell count in a specific module: Context: * Formula repeated several times in different line items and modules. And…
-
CURRENTPERIODEND() does not work
Hi everyone, I was having trouble when I start learning working on a module with switchover. I set the switchover on and set the month. It started okay, until I want to get the data from the beginning until the end of the period. I used CURRENTPERIODEND() function. But when I check out the output it turns out empty. I…
-
Get Min Date
Hi, I want to get min Date. I set Min as Summary. If any source item is blank, Summary shows blank. Is there any way to get min Date?
-
Compare two lists, one of it being numbered list
Can someone advise me how to compare two lists, one of it being number list ?
-
Calculation logic for different hierarchies
Hi In source module I am having Hierarchy list with 6 levels(L1,L2,L3,L4,L5,A) where A is lower level of hierarchy which is having some count line item. In target module I am having L5 as dimension with litem as Total Count. Scenario 1: Now we are moving A1, A2 from it's L5-1 to L5-2, where L4-1 is parent of L5-1 and L4-2…
-
Summing Values across dimensions
Hello - I have modules dimensionalized by an L3 hierarchy (Co/Dep/Sub) with the line items equaling Accounts that are "collected" through a LIS. Now I want to sum my values into an L4; which is just "L3" and "Account "strung together; but my formula of Sum - Lookup: the "L3" and "Account" attributes (Mapped to the L4) does…
-
Compounding Growth In Forecast Model
Afternoon, Composing a typical growth forecast. I am having an issue when my raw data ends. (FY23 is the last year). Then once I get into my forecast years, the lag function (and previous function) have nothing to pull from (zero value). LAG(Research Allocation Rate (Original), 1, 0) * (1+Growth Rate). So essentially for…
-
Quarter value of forecast for the Qtr in which switchover occurs
What are the alternative workarounds for this? When getting data from a line item Forecast version for a Quarter in which switchover occurs during the quarter, the QUARTERVALUE or [Lookup: <quarter>] return a value that only includes the Actuals amount for the month before the switchover date. (see screenshot)