-
Page Selectors for Large Lists
Hey everyone, I have not been using page selectors being published from a list very long, so I am trying to figure out the best way to work around what I am seeing. If a list is too large, I have noticed that the option for the +/- dropdowns go away in the selector. How has everyone been working around this? Thanks.
-
Update/replace renamed list items
How do you update/replace list items (other than manually) that have been renamed in a List assuming the existing list items are not deleted? E.g. Products - Existing Names Products - New Names Product 1 Battery 1 Product 2 Battery 2 Product 3 Battery 3 I tried importing but the new Product names are added to the existing…
-
Level 1 Model Building - Subset did not appear in Subset List
Hi The subset list (#E2 Employees: Active?) was created in the #E2 Employees List. Why is it that it did not appear under the larget #E2 Employees list and under the --- Subsets ---(i.e. Subset list). Please refer to the screenshot below. Thanks.
-
Lineitem maximum charecterstics
Hi Team, One line item maximum allowing test is 60 characteristics. I want to build module line items more than 60 characters required. I need to publish these line items on the dashboard. Is there any alternative to building these line items Anaplan? Kindly suggest me on the same. Regards, Uma
-
Anaplan Preformance
Hi If multiple users are using the same model at same time there will be performance issues . How to reduce these performance issues , Is there any solution for it in Anaplan ? Thanks Tejaswini
-
List subset
Hi All, I need to create a sub set of a list with all our assets. The subset should be dynamic and end user driven, e.g. all assets on HP or all right of use assets. The aim is to reduce size of downstream modules performing calculation only on the subset. Thanks N
-
Return lowest date on set of data
hi I have 2 dimensions, one is Dates and one is accounts, and I want to return the first date for each different account where an amount occurs and on future line in that account How do i do this? they all have the same dates associated with them, but that date ins't necessarily the first date with an amount for each…
-
Is Parent Boolean
Hi, Is there anyway to have a boolean formatted line item = True if it is a parent line item? Example: Line Item A - Applies to: L1 - Format: Boolean - Summary: Formula L2 is the parent list to L1 How can I get only the parent checked as true?
-
workspaceadmin question what happens if that person leaves
If there was one person assigned as a workspace admin for the training environment, what happens when that person leaves? How do people get access?
-
User Stories by Building Blocks of Anaplan
For each business process that is documented, it should have at least one user story that falls into each of these building blocks. Library: Define Lists: These are the user stories that hold the meta data of the model. Think in terms of the word “by”. For example: I want to see inventory counts by Depot, by Site, by SKU……
-
count of projects within user access
Hi, I have a list of projects that is in selective access. I need to be able to get the count or number of projects per user. For example user A has access to 1 project. Total count of projects is 4. When I do a count line item (formula = 1 ) my line item result if 4 even if I only have access to 1 project. How will I be…
-
filter does not show correct total lines
Hi, I tried to do a filter to only display 2 lines with totals but the total lines are not showing correctly. Total should be zero. It is showing total of lines even if those lines are hidden. Can this be fixed? Please see screenshot below :
-
Sum with conditions
Hi all, I'm having trouble with the sum function. I have the reference module [A] as below: Then I need to sum in Module [B] that only select the "SGA" element in "P&L Total" (which is a list) but I can't. The line item needs to insert the formula is "SGA" in the image below: I've tried all sum, select, lookup, select&sum…
-
Summary error - Summary set to Formula
Hi Team, I have a Boolean line item with a formula and when I set the Summary method to Formula I receive a 'Invalid combination of empty formula, and Summary set to Formula' error I'm a bit lost because the line item has a formula and hence there should be no issue with the Summary method Below is the both the error and…
-
Pre-requisite for QUARTERTODATE() and HALFYEARTODATE() Function
Hi, I would like to calculate the QTD and HTD in a module. It is noticed that the QUARTERTODATE() and HALFYEARTODATE() function are not working when the Quarter Totals and Half Year Totals been disabled in the time setting. An error message is prompted when the formula is saved. After the Quarter Totals and Half Year…
-
Calculate First & Last Week of each month
Original Thread (Credit goes to@JaredDolich ) Hi all Anaplanners, Your solution worked great, I just have a question to ask, so when we are trying to find the first and last week # that belongs to each month, it worked really well for the first year, it doesn't work well for the 2nd year because the week # would be greater…
-
Dynamic Ranking with Native Timescale
Hi, For a customer of ours I'm trying to build a dynamic ranking with the native timescale. The 'regions' should be sorted from high to low based on a fixed line item but on the previous month. Hope there is a workaround instead of manually sorting the values every month on the previous month in the dashboard. Kind…
-
There's nothing on the dashboard
대시 보드 삽입 후 열기 버튼을 클릭했습니다. 그러나 아무것도 없습니다. 뭐가 문제 야?
-
Issue with numbers as text
I am having the below issue with a number as text. it needs to be displayed as text, for posting into another system. in the attached, in IA local I am just using TEXT(ROUND('Investor Amount (Local)' * 100, 0) / 100) but as you can see on one line I get the number displayed in an odd format. I have tried rounding all over…
-
Mailto function won't open Outlook / Mail app
Hi community, In one of our models we frequently use the Mailto function. When I click the link, a new tab opens in chrome but Outlook doesn't open after. When my colleague clicks the link the Outlook does open. Pop-ups aren't disabled in my Chrome settings. Has anyone encountered this issue before? Thanks
-
How to show only write accessed items in a line item with list format .
Hi , I have list with selected access .A user has write for 4 list items but read for all items . There a line item with list format ,in the drop down user can see full list even though user has write access to only 4 list items . Any suggestion ,how to make it happen that user sees only 4 list items to which he has write…
-
Information for a Line Item Disappears when in Top Level
Hello, Good day! I hope every one is having a nice day. I would like to ask for any information that may help in troubleshooting this issue. I have a line item in a module called, "Credit Account". I have it in formula which basically says: If the Company is 'A' then use account number '12345', ELSE, use '67890'. This is…
-
How to make Date as a Display name in a Numbered list?
How do you make a Date as a Display Name in a Numbered list? I added a formula into my list properties with the format set as Date and the formula referencing the numbered list and the Date field. It pulled in the number properly to the Display Name. However, the new item created in the list is still a random number and…
-
How to create a comparative analysis model using lists?
Hi Anaplanners, I was looking into ways to create a model that allows end user to perform whatif analysis and compare the results (end user can choose multiple scenarios to compare). The user can select which version to compared via a list (list may contain members: Budget, Forecast, Forecast 1, Forecast 2, Forecast 3). Is…
-
Formula Summary
I have data formulas like this. How do you change SUM to Formula in summary. So Growth Calculate on Summary Level its wrong.
-
Quick verification of ongoing model health
My client is asking what checks their maintenance team can do to evaluate model health. I've come up with this list, am I missing anything? * Can you log into the model? (verify SSO functions and that the model loads) * Model load time and responsiveness (request model health report from CSBP) * Are users active in the…
-
Parent-level Commenting with Line Items Pulled from One Module to Another
I have a question about parent-level commenting with line items pulled from one module to another. There are line items in module 1, which are pulled into module 2 via subset and transposed into rows. In the screenshot, you’ll see ‘Salaries & Wages’ is the sum of ‘Salaries’, ‘Overtime’, etc. There’s a ‘Key Highlights’ line…
-
Excel user defined functions
If my Excel model has user defined functions, ie multiline VBA functions that are called by worksheet cells, can Anaplan handle them? I could not find anything about them online thank you
-
how to change the order of dimensions in " Applies to" ?
Hi, I want to apply the best practice of ensuring consistency in the order of dimensions, as described in following article: https://community.anaplan.com/t5/Best-Practices/Dimension-Order/ta-p/32934. However, when I apply the steps to change the order, nothing happens. What am I doing wrong?
-
Error : EMP02 - Dimension of mapping used for lookup doesn't match any dimension of the result.
Hi Experts, Please help on the below mentioned issue while adding formula for Bonus, Car, Phone costs & Medical costs to the EMP02 Module. BonusIF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0Car costsIF Employed? THEN…