-
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…
-
dependent dropdown multiple condition
Hi, Is there a way to make a line item( dropdown list format) to have multiple conditions? example : I want my GL account dropdown to be filtered based on the account type selected (parent of the GL account) and based on the cost center selected? GL account is dependent on both the cost center selected and the account type…
-
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…
-
Reverse mapping
Hi all I have a source module with dimension list A and an output module with list B. To bridge this, I have a simple third module where the end-user can input the mapping between A & B. This works perfectly for a standard LOOKUP formula. I was wondering if there's an easy way to reverse the mapping? I basically want…
-
Need to remove duplicated text values from a text Line Item
Hi Members, I have an requirement of identifying unique values of customer in each department. Please see below module which is have a dimension of departments list with three list items(D1,D,2,D3) and a line item(Customer Names) which is having concatenated names of all customers in each department with delimiter as ",".…
-
Need to break down Module into Multiple column Flat List
I need some help breaking down data that has been inserted into Anaplan via the excel add in, so that each component in the existing module can be listed as individual line items as in a data list. The attached photo lays out the dimensions I need, but I'd like to see it in a form that has the Cost center, Ledger code,…
-
Only want user to put in one value
Here's the situation: I have a module with two Boolean line items that should act as the inverse of each other. As an end user, I should not be able to click both boxes. Screenshot below Basically, If the user picks the home team to win they should not be able to choose the Away Team to Win. I thought IF…
