-
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…
-
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…
-
Job Aid: How to use the new Model Search
@VickiA posted all the New Modeling UX features in this post. Just wanted to show you where the "Model Search" magnifying glass is located. Took me a while to find it. It's terrific! Already used it to clean up one of my models - used it to search for line items used for filters that I want to change, particularly the time…
-
Is there a way to view Months then Quarters then Years in a Module Applies to Time
Hi All, I have a Module which Applies to Time. Attached Screenshots. =>The possible view for the Timescale is Jan Feb Mar Q1 Apr May Jun Q2 Jul Aug Sep Q3 Oct Nov Dec Q4 FY =>But is it possible to have a view like this Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Q1 Q2 Q3 Q4 FY Regards, Sreeroop
-
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…
-
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?
-
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…
-
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…
-
Compare two lists, one of it being numbered list
Can someone advise me how to compare two lists, one of it being number list ?
-
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…
-
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…
-
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)
-
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…
-
Rank list items based on multiple ranking levels
Hi Anaplan users, I am trying to rank PO values by cost center & cost element & period & vendor & PO value. See screenshot and blueprint view attached to follow my reasoning below: I first want to show all POs from the vendor with the highest PO value at vendor & cost center & cost element & period level. That is what I…
-
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…
-
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
-
Module with Users List
I have a module with two dimensions, Users List and Line Items. Ideally, we would like two Boolean formatted line items (Single Sign-on and Workspace Administrator,). Is there a way to import / write a formula into the module that pulls the information from the users section under model settings? This could apply to model…
-
Polaris vs Hypermodel
Hello! Exciting new product releases coming from Anaplan announced at Anaplan Live! 2021. One of things a lot of us are curious about and want to know more about is Polaris. What is the difference between Polaris vs a Hypermodel? - Hypermodel gives users the ability to have up to 700GB's of space in a workspace - Polaris…
-
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…
-
Ratio of each accounts product sales by country's previous year actual sales by Prod Family
Hello, This question is related to user story 1.3 and 1.4 We want revenue for each account by product. Further we want to take its ratio against country’s previous years actual sales revenue by product family. Are we looking at a module with dimensions of Country, Product Family , Account & Time (Quarter) to calculate the…
-
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…
-
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
-
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!
-
GL's available by Property, Owner, & Expense Category
Hello Everyone! I'm working on a budgeting model and need some help. Happy to provide any necessary details I may have omitted. We have a handful of properties (ownership specific) that need to budget in a specific GL account, while the remaining 90% of properties shouldn't have access to the GL in question. Currently,…
-
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'.
-
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!
-
To display code of Child and parent in a single line item
Hi, Is it possible in Anaplan to display the codes of both Child and parent in a single line item. I have requirement to show the code of both in the same line item. If its Boolean then Any or All summary would work since its text and the list would be at child level I can't apply Formula as a summary so any work around…
-
hotw to obtain period of line item
Hello, I'm stuck on a formula that seems obvious to me. I would like to retrieve the time period of a line item : Week : list formated. time period by week : format time period, applies to week => i want to obtain time period for each week. Any idea? thx for your time !
-
FY Values replicating QTD Values
Hi Anaplan experts, Maybe you can help me with my issue? I am building a module that requires to show the current quarter (CQ) as a YTD value without summing up as FY. It means that if selection is Q1 or Q2 or so forth, FY value should be whichever the month or forecast month selected. Sample ss below: Hope you can help…