-
4.8.2 Activity: Import Data into E2 Employees# List
Hi All, Has anyone completed exercise # 4.8.2 Activity: Import Data into E2 Employees# List? I am not able to procced with this, can anyone j
-
Calcuation of subsets as my allocation basis
Hi guys, how can i get the totals of my subsets in my formula so the totals of my denominator will only be the totals of the subsets? Thanks in advance.
-
Max Value for a Line Item on a yearly basis
I am trying to find the max value in a different line item for any given year, all in the same module. time is in months so my start month would be january and end month would be december. so for 2023 I want the max item, for 2024 I want the max item, and so on and so forth.
-
Update Historic Volumes for Baseline Forecast
Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast…
-
Omit the calculate lineitems by using Lineitem subsets
Hi, I want to omit calculate Lineitems by using Lineitem subset. I have these Lineitems. I have to calculate each(A,B,C…) error(= Forecast - Actual) . But in this table , I have to create at least 4Lineitems and input formulas. Category Lineitem Value Forecast A_forecast 100 B_forecast 10 C_forecast 200 ・・・ ALL_forecast…
-
Level 2 1.5.8.1 Create Saved View for DAT03 Module - summary method
I'm on Level 2 1.5.8.1 Create Saved View for DAT03 Module, and I have Monthly subtotals in my saved view and I can't see how to get rid of them. Other than that my saved view matches the requirement. Here is the requirement screen shot: And here is my screen shot: There is a hint in the activity about which summary method…
-
Enable Conditional Formatting using Booleans, Dates and Texts
Presently conditional formatting logic works only on number data type. If it is made to also work on other data types available such as Booleans, Dates, Texts (and lists may be) it would be very helpful and we won't have to work around the missing functionality.
-
Level 1 8.8.4 Activity: Add Formulas to Size Margin Report Module
It won't accept the formulas for Revenue and COS. Not sure what's wrong.
-
Option to set default label height on Boards of NUX
We have to manually change the label height for each and every card on the Boards of NUX from the default of 3 lines. This consumes a lot time and effort. An option to be able to set a default label height would be so useful.
-
Option to change card type
Option to select a card and change the type of the card would be a nice to have feature. For example, selecting a grid card and changing it to a chart. Presently we have to delete the previous card and create a new one. Meaning reapply filters, reselect line items, re-pivot the dimensions, re-select the levels to show.
-
IRR function to operate on a specified time period ranges
Hello team I would propose an idea of IRR function enhancement to operate on more dynamic environment and respect Anaplan time dimension in the same way as TIMESUM function. Why it is necessary? For IRR calculation when the sign of the cash flows changes more than once, for example when positive cash flows are followed by…
-
Configuration & Release Management System
The Situation I currently help manage a set of models ranging from Dev, Test, & Production. Our Production model is live with close to 700 users. We release changes into production on a 2 week cadence but there are times where a fix must be pushed live immediately patching. Some new features may take longer to develop 2…
-
Level2 Sprint3 3.3.5.3 Check Your Work
Hello all, After inserting the formulas to INV01, my numbers aren't exactly the same as the screenshot on the instruction. Where I might've made mistakes? This is my blueprint view:
-
OEG Best Practice: Anaplan Performance Triangle
Building well performing models is a balance between the complexity and functionality of a model versus the number of concurrent users. If you have seen software development / project management triangles, where scope, time and cost control quality, this will be familiar. It is a good way to show the constraints of any…
-
Joint Deployment Blueprint
Hello, In Anaplan Way training (The Pre-release Phase) the Joint Deployment Blueprint document is referenced, but the link does not work. I also searched but could not find a result. Is this document updated and renamed? Best, Murat Akkas Excerpt : Joint Deployment Blueprint for Anaplan employees and partners–Anaplan and…
-
Is it possible to change the order of list items in Saved View?
Hi! I want to change the order of items in the list used in the horizontal axis of the Saved View used in the Export Action. It is possible to rearrange the order of list items in the Apps screen, but is it possible in Saved View? Is the only way to change the order of items the only way to change the item order in the…
-
12.4.2 Create Saved View for Country Margin Report
Hi, I'm working on Lesson 12 in Level one. My issue is that the example data is slightly different from what I've been building so far. I'm not sure if it's the format or formula from the other modules. Please send suggestions
-
Is Summary Behavior
When a line item is included in a sum the Is Summary automatically enabled. This can be disabled manually in blueprint mode. When adding additional line items to that sum, the Is Summary automatically re-enabled. This default behavior has some undesirable impacts for exports where summary items are omitted. A quality of…
-
How to refer a properties in formulas
Hi, How can we refer properties in formula
-
Level 3 Sprint 2 - 7.3
Hello, All my formulas required for Activity- 7.3,Level 3,Sprint 2 appear to be correct. Kindly confirm the Net Commission formula. As the figures I have arrived differ from the activity screenshot.
-
Better Formula Editor for Anaplan; A Chrome/Firefox/Edge Extension
Hello all! A while back I made a Google Chrome and Firefox extension that enhances Anaplan formula editing by using the Monaco editor (currently 700 users). This is the editor used by Anaplan's new modelling experience. My extension works with this new experience adding enhancements over and above what Anaplan have done.…
-
Schedule vs. Snapshot of Line Items
I have a schedule with two line items below showing exactly how the parenthesis should be. When the snapshot is taken, the parenthesis shows differently (second screenshot). Does anyone have an idea of why there would be a difference in the line items after the snapshot has been taken?
-
Гигиена моделей - время уборки
Всем привет! Мы восстанавливаем активность в группе, ведь весна - время обновления. И ваши модели не исключение! Есть много причин провести гигиену и оптимизацию моделей, особенно если им несколько лет. Если вы решились на «генеральную уборку», вот на что стоит обратить внимание: Старые костыли и «брошенный» функционал…
-
Multiple Model Builders
Hello, We are at a point with some of our models where we would like to train up new model builders to take over the ongoing maintenance and tweaks to a given model. We are debating the wisdom and practicality of allowing multiple users to have model builder access to a single model. Currently I can argue both sides of the…
-
Line Item Subset: include non-numbered members, boolean only for dynamic filtering
Using line item subsets to filter line items in and out of a view is very helpful in giving users the ability to change their view in a single click; however developers are limited to Number-formatted line items. Giving the ability to add non-numerical items to a LISS and limiting the format of a line item dimensionalized…
-
New UX for modeling: Formula broken down into lines & color coded
In the new modeling UX, it would be great if the formula is broken down into lines and indented when different parts of the formulas are in use (especially for multiple IF statements). Right now, even though the colors change per formula, it's hard to find where the breaks are. Additionally, right now every IF statement…
-
11.3.2 Activity: Import Data into P&L Actual and Budget
In 11.3.2 Activity: Import Data into P&L Actual and Budget I cannot import any data to the Budget version as it seems like only Forecast and Actuals version exist in the new model I have created. However I cannot tell why the budget version is not there? My systems module for version looks like this: And versions is set to…
-
Better Formula Editor for Anaplan; A new Chrome/Firefox/Edge Extension
Hello all! I have made a Google Chrome and Firefox extension that enhances Anaplan formula editing by using the Monaco editor. This is the editor used by Anaplan's new modelling experience. My extension works with this new experience adding enhancements over and above what Anaplan have done. It also works with the…
-
Option to sync Dimension Order across all modules with the click of a button
If we had a button in the Modules pane to sync all dimension orders, we won't have to manually (for each module) click on the applies to section and close
-
Level 3 Model Building Sprint 2 Territory Data
Hello, Many of you have probably finished the Level 3 Model Building Certification. As I start Level 3, Sprint 2, I got confused with the below instruction: My questions/clarifications: 1. In Sprint 1, the Level 3 Model is connecting with the Data Hub, and there was an option to download a New Data Hub or Use the Data Hub…