
Modeling
Modeling
Discussion List
- Hi Anaplan Community, I’m trying to automatically generate and send an email from an Anaplan page formatted as follows: TO: (Predefined recipient email) Subject: Text [dd-mm-yy] Attachments: (Optional…
- Hello ! It would be great to have automatic quick-wins regarding Model Archive Management ! ALM & Archives : When we need to move a large number of developments (or time management switch) into produc…
- I want to allow users to input a text field with items separated by commas (e.g., X1,X2,X3,X4,X5 ) and, after clicking a boolean (e.g., "Select"), have the page filtered to show data only for the spec…
- I have a text string like "X1,X2,X3,X4,X5" and I want to convert it into a list containing X1, X2, X3, X4, and X5. I tried using FINDITEM, but it only works for one item, and with FIND, I can only get…
- Hi, I'm struggling to filter a table in NUX based on the page selector. Anaplan wants me to hard code an item to filter on. I want it to use the selected item in the page selector. I have a bunch of p…
- I have a three level list Country->Region->City. How can I display selected line items for a given level in the list. Let's say I have 10 line items in the module and for Country level I want to displ…
- Ability to add notes / comment out formula parts in the formula editor similar to '- -' in SQL or ' in Microsoft Visual Basic
- There should be a syntax to add comments within the formula. All programming languages provide this feature, for example: /* comment */ is used in Java, plsql. This will help to temporary remove any p…
- It would be great if I could create dependent dropdown lists with Time Period type. E.g. I have 2 line items with FY and HY types. And when I've selected FY18 in the first one, the second dropdown all…
- Author: Ethan Rold is a Certified Master Anaplanner and Senior Manager at Grant Thornton LLP. Winter in the U.S. is basketball season, and it is in full swing. When you attend a high school basketball…
- I struggled in this activity where we applied DCA to Override Forecast the forecast line item. I was thinking of writing a formula here in the Override Forecast Line item like below but I am not sure …
- I have a hierarchy consisting three levels (product/product family/total products. Similar to the one in the trainings) and I tried to do some conditional formatting on it (need to use it as other tab…
- As an end user I want my parent hierarchy results to show in bold in tables so that they are quickly and easily distinguishable from the rest of the data Currently the parent item name in the list sho…
- Our August Community Challenge invited people to share creative or useful Anaplan models they've built, and WOW — the Community delivered! We recently hosted an event to walk through a few of the uniq…
- Hi all, Bit of a complex one here. The application use case is calculating the Minimum Variance Efficient Portfolio for those familiar with Finance / Portfolio Management. The Anaplan question to be s…
- Hi! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and gu…
- I am requesting the ability to order pages in any order we choose. Currently, the new UX defaults to alphabetical ordering of both pages and categories, but I would like the ability to order these in …
- Hi, I am struggling to get numbers for the Baseline Forecast line item my formula looks like the below: IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG('DAT03 Historic Volumes'.Volu…
- Hello, everyone. In the near future, I will be introducing a supply chain model (from demand forecasting to supply and inventory planning) to a Japanese Manufacturing company as a Model Builder. As pa…
- Hi, I am struggling to get numbers for the Baseline Forecast line item my formula looks like the below: IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG('DAT03 Historic Volumes'.Volu…
- The ability to have user specific DCA is great as it allows fine grain control of line items/modules without add dimensions to them, but... As we are dealing with large models with increasing number o…
- Hi Everyone, I have completed my Level 2 in April 2019 & Level 3 in June 2020. After that, I have switched my job so both the models are in old organization's workspace & transferring them to new work…
- Our company is a real estate developer and I am having a problem dealing with too much data. For example, we consider our condominium units as our products. These units are unique from each other (i.e…
- Created the SYS01 Time Settings by Year module, added and formatted the line items, and added the formulas .. How do we properly add dimension on this one?
- Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. As go-live approaches and admin and end user training gears up, the question of ‘how do we document the mod…
- The formula for Line item Revenue and Cost of Sales line items is not working and giving an error as below. This is from LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculati…
- I have a line item that has a list value. In another module, I would like to sum based on that list value -- without adding that list as a dimension in either module. Is this possible? I know this syn…
- Has anyone had any success publishing a subsidiary view line item in Fluence grids? I have a line item in a module that is a subsidiary view used for mapping GLs. I need an end-user to update the mapp…