-
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)
-
Hide certain list member in dropdown
Hi, Is there a way to restrict user access in certain list but they should still see the amount when being aggregated at total list. I need to restrict user to all modules so using the picklist would be little tricky as I need to update everything. Thanks in advance for helping. Tom
-
How to create a boolean with Radio Button like properties?
Hi Everyone, I want to create a boolean line item in a module dimensioned by a list, which can only be true for one list item only at a time. Let's say, the list has 10 members and initially that boolean is false for every list item. User checks the boolean for list item 2 and then User checks the boolean for list item 5…
-
Sync only the clicked members in the insight grid in Worksheet Page NUX
Hi Everyone, I am facing a problem in NUX worksheet page. When I click a member in the worksheet, the insight grids syncs to the immediate parent level hierarchy and shows all the siblings of the clicked member but I only want to see the clicked member only or differentiate it from its sibling after clicking (like…
-
Average for a Period of Time for Next Period
Hi Team, I am trying to calculate the "Average" for a Expense for the Period of "FY24". And I want to calculate using the Average from Q3 FY22 to Q2 FY23. On the "actual line items are the expenses for prior quarters and on "RunRate Line Item" I want to calculate the Average for those 4 prior quarters. I am try TIME SUM…
-
Forecast range in Statistical forecast APP
Hi, I want to use Statistical forecast APP. This app presupposes forecast 1 Month? Some Forecast method only forecast 1 month like Winter's method. I want to forecast 1 year. Is there any setting to change forecast range? or I shouldn't use this method?
-
Restricting Users to their own content
Hello Everyone, I searched the community for this a couple of times and came across this article that actually just confused me more (see below) and I am hoping for clairty. https://help.anaplan.com/56391e35-2831-4642-b6de-2dddb6c68cfa-Default-lists I currenlty have two roles - Admin and Users. If I wanted to restrict…
-
Publish List and there Subset in the NUX
Hi Anaplanners, I have came across problem in which we are migrating from Dashboard to NUX and as of now in NUX there is no facility of publishing list directly, workaround for it would be adding modules and publishing it directly for the list and their properties but what I want to know that in the list we have provided…
-
Users Names
Hello, Can we get the User name in a lineitem if the module is not dimensioned by Users? Thanks Devika
-
Cannot add Revision tag
Hello, I am trying to add a revision tag to the test model so I can compare and sync it to the production model. However, the button to add the revision tag is disabled. Please note that the model is in 'Deployed Mode'.
-
Translating % correct into a RANK()
Hello, Question - I have a module to calculate the percentage correct (e.g. 75%) and I want to be able to rank this on a scale of first to tenth place. Advice on how to do that? I tried using the RANK() with the module calculating the percentage correct and could not get a solid translation. Thanks in advance!
-
Z Score for Safety Stock
Hello, I need to build a formula to calculate safety stock in Anaplan. I have lead time & usage data available. I am inquiring guidance with developing the z score formula. Inputs will be appreciated, thanks!