Modeling

IF list item 'x' THEN 'do this' ELSE...
I am trying to do an IF statement within a module dimensionalised by a List ('Volumes') which has 2 members: Retails and Wholesales. I need to do a particular calculation depending on if the 'Volumes' are Retails or Wholesales. I have tried IF Volumes.Retails THEN x ELSE y but this not work, giving the following error…
Non availability of Map Chart in new UX
Hi, I am not able to see the option of map chart yet in the list of available options in Charts card in new UX. Is this also planned to be added in the next release. Do we have any alternative for the same as of now ?
YOY-Growth% Calculation
Hi, I would like to calculate the YOY-growth % between year to year but it seem I fail to calculate the number even I bring the Previous Value also. Thanks, Kiwi
Increase the character limit of the MAILTO function
The MAILTO function currently has a limit of around 2000 characters and any greater than this will prevent the message from being opened in your chosen mail app. This is normally fine for standard English alphabetic characters, but can cause issues for non-English alphabetic characters. For example the Japanese character キ…
Why is the line item format selectable?
Why do we need to set a format for the line item on creation, can it not be a read-only field and set based on the formula/data. Anaplan knows when we get it wrong, why not just set to what it is supposed to be?
Another work around method
Hi, I would like to ask if there are any other work around for the attached issue. Please see attached document for details. I was able to get the desired result using the IF function but I want to know whether there is another approach to it. Regards,
Short data for import
Hi Anaplanner, I'm import data like this, but i want to sort data based on color before im import to another after import the data will be like this can anaplan provide like that? Thanks, Panji
Import into a List Formatted Line Item
Hi, I am trying to import value(top Hierarchy) from a list A formatted line item to another List A formatted line item. But the import is getting failed. Is it possible to have this kind of reset action to make the selector to ALL(top Hierarchy) by default when nothing in the list is selected by the user. Example: Select…
Define Multi Dimensional Level Payout grid
I have a scenario where i have to calculate the commission based on multi level payout grid. Input : End user will be able to define payout grid at any level of dimension by month on month , based on that particular month payout structure. Ex : April month Applicability of Payout at 2 level of list i.e A,B. Assuming Each…
SUM vs LOOKUP - Visual Representation
For those like me who like visual aids, I put together a diagram of when to use sum vs lookup in a formula. Hope this helps if you are struggling when to use each.
Ability to get to know "Published on" App/Page feature
Since we are moving away from classic dashboarding slowly and NUX being the future of reporting in Anaplan we may need to know where the modules have been published on NUX. Hence proposing an idea of having an ability to get to know about the "Published on Page/App" feature in Anaplan Models. It needs to be precise to tell…
Saved views reference
Hi Anaplaners, Is there a way to know if and where a saved view is used? in case I want to delete it. It's easy to determine if a module or a line item is referenced and where. Anything like that for saved views? Thank you -Einas
How to keep current time scale data intact while moving to next Current period
Hi, Just for my understanding, What I need to do in Anaplan so that when I change my current period (Q1) to next quarter (timescale Q2), my current quarter (Q1) data didn't not get delete and automatically covert to hard coded figures. Thank you!
DCA, Filtering and Export Referencing
Few things make me happier than tidying up a model. It's good to delete out redundant content to remove clutter and reduce model size. The first place to look when doing this is list, module and line item 'references'. If it's used by another module or on a dashboard then you know it's in use. However, there are scenarios…
Filtering on USER
Hi Team, I'm wanting to filter a list dependent on which USER is viewing the module but I do not want to include USER as a dimension in the module I have a Filter Module which has the Department List, USER list and a Boolean line item to indicate which Users I wish to have view access/filter access to Departments The…
Allow customers to reset list entity index by themselves
Description of the enhancement required Allow customers to perform list entity index reset for their lists that encounter "IllegalArgumentException: Maximum entity index value is 999999999" error. A story for why they want the enhancement, (how would it help their business process) Anaplan support needs to cooridate with…
Snap to grid on dashboards
It would be really useful to have a snap to grid feature in both the new and old UX dashboards. New UX Vertical snapping: currently none. Horizontal snapping: limited useability. Improvement: allow users to snap to grid vertically and also allow users to adjust the grid size (by percent or pixels). Old UX No snap to grid…
Importing is not updating correctly
Hi Friends, I am trying to import this .csv file into my module. But I can't do so. I think I need to create a Col ID. My ques: will the newly created Col ID able to match data in another module with different ID? I will brief my problem elaborately, in case you find any difficulty in understanding.
Import Help requested
Dear Friends, I receive this file every month from the vendor. I want to automate the process of adding the file. I want to follow the process of certification. Please tell me, how is it done.
Multiple lists as only dimensions and LOOKUP
Hi, I wish to lookup each and every individual cell in a module that is dimensioned by 2 lists. No time dimension. I have a Module "Sequencing" dimensioned by 2 lists - MonthNames and Offset. Attached are screenshots of the two lists and the module. The module has one line item - a % number that determines for each month…
Who's interested? Office Hours with Rob Marshall - presented by the Anaplan Community
Alright Anaplanners, we’re giving you direct access to Anaplan experts to answer those tough questions. Is there a formula you are struggling with? What about a list or line item? Getting stumped working with a specific dimension? We’ve got the expert and the answers! How does this work? Well, if we’re honest, this is our…
Using subsets as conditions in the formula of list properties
Hi , I need help on the subject . I would like to give a conditional formula for one of my list properties based on the list subset involved. Please let me know if this possible , if yes, how ? Also if not, please suggest alternatives. Thanks in advance! -Aishwarya
Parent / Child - Formula
Hi Community, We're stuck on a formula and not sure if it is remotely possible in the first place. Can a Boolean be TRUE for the Parent but FALSE for all the children? To give some background: In a Planning model on Dynamic Time (lists, not native time) we have Week - Day hierarchy. On the dashboard there's a 52 Weeks…
Filter History by Users
With growing number of changes being recorded in the model history it becomes very difficult to analyze the exported file of Historical Changes esp when we want to track changes for a month or two atleast as the file can become quite big to play around with. Hence Proposing an idea of having an ability for a model builder…
Update Master data based on approved values
Hi Can I know how to update existing master data with approved values at end of approval cycle without overriding the existing data set ? Thanks Tejaswini
Have total in summaries to only include sums of only the items users have access to
It would be useful to have a sum that only included values from list items the user has read access to. So if you have a list with items A, B and C, and one user only has access to A and B, they would still be able to see a total of their view (A and B) . Why this would help: When using selective access, not all views roll…
How to maintain same order of "Reselect Items to Show" between multiple environment
Hi Expert, Please provide me with some advice and help my model building. The situation is.... 1. In Development environment, Production Data List (Custom Week, such as 2021 W01) as dimension is selected and rearranged by "Reselect Items to Show" on a dashboard. 2. This setting is imported to Production environment via…
Circular References - OFFSET
Hi, I want to create something like the below example, but Anaplan returns circular references. Could you please give me an idea? Example In the above example, I input below formulas Last month stock = PREVIOUS(Stock) Consumption = get from different module Planned Received Amount = OFFSET(Recommended Order Quantity, -1,…
Level 1 MB Lookup function issue
Dear, I am trying to apply a lookup formula to retrieve data but I always get an error message that is not mentioning what is the error. I think my data should be ok, as well as the formula I entered but still I get error messages. I attached the input of my formula and the error message i get. Many thanks in advance! kr,…
Search Functionality in 'Manage Models' Window
With mature Anaplan workspaces, there are typically dozens of models that would have been created during Foundations, development or for sandbox uses. As the list of models grows, it becomes hard to scroll through the list to find a specific model. This difficulty is especially evident in partners' workspaces, where there…

Modeling

Discussion List