Modeling

How to give a group of dates as a condition?
Hi, I am trying to build a training diary that should prompt an error message whenever public holidays are being selected. For example , there are 10 public holidays in a year. I need an error message to be prompted while choosing any of the 10 days. How do I use these dates in my formula conditions? For example, the dates…
Limit on Input values
I want a certain limit on the total of my input data: * List of 5 products * Input Module in which a percentage can be inputted per product * The total of the percentages can't be more than 100% Is there a way to show a certain error message once the input results in a percentage of more than 100%? Thanks! Faas
Find date related to boolean line item
I have build a module with time over the columns and a flag as a line item. Now I want to extend this flag to an x amount of periods, starting from the date flagged in the current flag. In order to do this I would like to find the date attached to the TRUE value of the flag, then sum the amount of periods to this date, and…
Check dependency on a dashboard before deleting a module
I have been cleanning up a model and deleting modules I thought I did not need. I was doing it based on the field "Referenced By" however, this field only considers module references. I would like to suggest "Referenced By" includes everywhere where a module is used, for instance, dashbboards. This way, someone cannot…
"Merge Heading" Feature to Group/Separate Same Line Items
1. Adding The Merge Header Feature, or "Line Item Header 1" will allow us to group Line Items wit hthe Same name in the module, using the same line iem, and organize the structure overall in a way that is more efficient to build and report. 2. Merging the Line Item Headers will shorten the Names of the Line items and make…
Workflow email
Hi, Is it possible to customize the email template sent from the workflow view? Thanks!
How to run a process from another model?
The title is pretty self explanatory, but if I have model A and model B, is it possible to create a process in model B to runs a process in model A?
Text Calendar
Hi, Lets start with a picture I have a module with brands, promotions and periods and some text, and would like to present them similar to the above picture. I have not seen or used a module where text is displayed in periods, and before i started trying to work it out, wondered if there was any suggestions, advice or…
Generic app to convert flat ragged hierarchy to composite hierarchy
An example of the enhancement: It would be helpful if there is a generic app which can be used to convert flat ragged hierarchy to composite hierarchy. The only difference between ragged hierarchies are LEVELS. If we can define the required LEVELS in the app and load the ragged hierarchy, we should get composite hierarchy…
Open multiple models in 'tabs'
It would be extremely useful when working between models to be able to open them within side-by-side 'tabs' within one browser tab (a la Smartsheet), and avoid having to exit the model back to the dashboard.
Collapsible Textboxes with ability for users to pin it open
For more complex dashboards, showing informative instructions can take up some major screen real estate. I find on first pass a user may want detailed instructions, but after they know how the dashboard works, they want them out of the way, instead of always having to scroll past them. As a model builder, I would like the…
Dynamically Update Module Views when filter using line item contents change
On some dashboards showing large amounts of information, we will have a smaller "Smart Filter module" where the user can select values for line items in it. Once selected the main data table's filters will filter based on the Smart Filter module, the trouble is the user has to refresh the page to see the filters reapplied.…
Enhanced Textbox Styling & Formatting Options
I would like to be able to apply common styling to text in text fields to help me provide end users with a better user experience. Specifically, I'd like the ability to change the size of the text field itself, the text alignment, text color, font, style, size etc. Also the ability to turn off the auto-appearing scrollbars…
Ability to set textbox style & size when adding it, and at a specific location
I would really like the ability to select what size and style of textbox I'm adding at the point when I'm adding it. Currently when adding a textbox it is added at full page width, defaults to "Normal" style, and is added to the very top of the page. Usually when I'm adding textboxes, it will usually end up being a small…
Header & Footer zones on dashboards that don't scroll
In our model, we use navigation action buttons to help a user see "where they are" in a workflow with respect to other similar pages. Usually this amounts to ~4-5 buttons near the top of the dashboard in an order logical to the workflow, which are in the same order across all of the workflow's pages. Unforunately when a…
Use three versions in model
Hi, I'm trying to build a rolling forecast model that has actuals, budget, latest estimate and forecast with the following dates: Current month = jul 2015 Budget = currenlty available for 2015, should be updated every year Latest estimate = sum of actuals and remaining budget in the current year (2015) according to the…
Anaplan function equivalent Excel MATCH function
Dear Anaplaners, What is the Anaplan equivalent function for the "Match" Excel function. I have a list "Age braket": 0 to 10 years 11 to 20 years 21 to 30 years Above 30 years I have 2 line items: Age : format number Age range : format: list "Age bracket" If "Age" is 25 , I would like to edit a formula in "Age range" with…
Formula to number a line item to create an order 1,2,3 etc.
I am creating a module that will be a template to import into our ERP. One of the line items is called 'Journalnum' which essentially needs to start at 1 and every line thereafter will be 2, 3 4, etc. E.g. in excel cell A1 is journal number 1 and cell A2 will be a formula to equal A1+1. There are 1000+ lines in the…
Display few months of data based on time selection
Hi All, I am working on particular client requiremnt. Where, the user dashboard has time as page selector (weekly format). Each time the user selects the particular week, I need to display that particular month and last 2 previous month data (not weekly). Note : In other words, I have a "movingsum" formula which is…
Year over Year Growth
Hi - I'm trying to calculate year over year growth in the time summary lines for my fiscal years. I can calculate year/year growth for each quarter (we are viewing our year by qtr only) using the offset function - (Revenue - OFFSET(Revenue, -4, 1)) / OFFSET(Revenue, -4, 1). However, Anaplan doesnt' allow the offset…
Effect of Deleting Module Views
All, I currently have a module that is taking about 30% of my workspace and I am looking into ways to bring the data usage down. I had a couple of questions about multiple views that I saved for this module: * Does bringing down the number of views bring down my data usage? * Is there a way in Anaplan to see which…
Simple Sum
Hi I have 2 modules, EPOS Daily Module which has EPOS data stored with a 'cust-bvfsku' and a date, updated on a daily basis. Then I have a top level module EPOS Sales List Module, which has a single line for each unique Cust-BVFSKU, and a start and end date. I want to SUM the p_unit Qty from the top module into P_Sales in…
Single-precision numeric format option
Number-formatted line items and properties use a double-precision representation internally, and at least double precision during calculations. They are specified in the IEEE754 standard as a signed binary floating point format with 52 bit significand and 11-bit exponent, allowing a range of 2.2*10^-308 .. 1.8*10^308 and a…
Quickly Sort Row and Column Labels
Add an option to quickly sort labels alphabetically by using something like the right-click menu. This wouldn't necessarily need to be saved after the model is closed, but would act as a quick way to order the list and allow items to be found more quickly because they are in alphabetical order.
Need help on intermediate model building course , 12 section Rep quota part
IF NOT Active? THEN 0 ELSE IF YEAR(START()) - YEAR(REP SETUP.Start Date) = 0 THEN MONTH(START()) - MONTH(REP SETUP.Start Date) + 1 ELSE 12 - MONTH(REP SETUP.Start Date) + (YEAR(START()) - YEAR(REP SETUP.Start Date)) * 12 - (12 - MONTH(START())) + 1 Please explain me this formula for tenure for Rep quota?
Improve performance of list property imports
Description of the enhancement required: To load data into Anaplan, we need to load data to a list in order to populate items. We also hold all properties of the list in modules as line items for performance reasons. To complete a data load, we need to run two different actions for every data object we bring into the…
Different Dimension of two different modules
Hi, How can we manage to move data from one module to another eventhough thier dimensionality is different? Is there any standard solution approach to this? Regards Wasim Nasir
Open Dashboard : Auto Close Current Dashboard as an Option
As a model Builder, I would like to be able to choose, when I create a new "Open Dashboard" action, to choose if the current dashboard have to be automatically closed when the user clic on the button in order not to cause confusion and not to suggest complexity. Context : 1) When we create an "Open Dashbaord action", we…
Improve message description on error message displayed
It is not clear to many of our users that they need to click on OK on the message attached in order to go to next step. This happens alot at quarter rollover. When we are done with a quarter we archive the model for that quarter. SFDC automatically tries to bring you to the last model you accessed. The last model they may…
Lookup Function -enhance this function with adding ability to ignore module's default dimensionality
Description of the enhancement required: Lookup Function - enhance this function with adding ability to ignore module's default dimensionality when using lookup. Pain - currently you cannot set another search argument instead of module's dimensionality, module's dimensionality is always used as lookup priority in Anaplan.…

Modeling

Discussion List