-
Level 3 Commission Forecast
I'm currently struggling with the calculation of the monthly commissions FC. Issue: Quarterly commission Forecast: Unable to get quarter values by sales rep. How to bring down Annual sales target into Quarterly? Kindly help me on this.
-
anaplan academy tag
Hello, please i want to ask you where can i find my anaplan academy tag? Thanks,
-
Browser Slowness when Model Building
Has anyone else noticed that after 15-30 minutes of model building activity (opening modules, opening lists, updating formulas, opening split views, toggling from blueprint to module view, etc.) that browser tabs slow down and stop responding, and has to be restarted. Been an issue for a few weeks now. Hardware and…
-
Applying one Pivot Filter to multiple cloned connections with the Excel Addin
I have one Excel workbook with multiple worksheets and I want to apply one Pivot value filter (e.g. Time - May 21) to all the worksheets. Rather than updating each individual worksheet "Time Value".... When I used reference this value across worksheets it is blown away after the refresh.
-
Level 1 exam - model building activity 2
Hi, I'm trying to do the activity 2: "update the REV02 volume inputs module to include a formula to pull data from the DATA 02 SKU Volumes module". And tried the formula: 'DATA02 SKU Volumes'.Volumes but I get the error message: Level mismatch on common dimension Can
-
Conditional Formatting for Combination charts
It would be great if we could include conditional formatting for combination (maybe even column / bar charts) to quickly indicate to users if a measure if performing better or worse along the x axis. As an example, if we are trying to show a month that is performing lower then expected, we can make the column red while…
-
Level 2 Training - Sprint 3 - 2. AD02 Inventory Ordering Overwrites
* Override Amount – Write: IF 'INV01 Inventory Ordering'.Override Suggested Order Amount = TRUE AND 'INV01 Inventory Ordering'.Submit Purchase Order Request = TRUE THEN TRUE ELSE FALSE ----Does this not look correct?
-
90 days work space access
Team- I am looking forward to free workspace as I need to complete my Anaplan certifications Anaplan Case Number: 00475525
-
Entrust CA Certificate - Error outputting keys and certificates
Hi there guys, anyone using Entrust CA Certificates for Anaplan Data Integration? Following the recommendations from Anaplan's list of Supported Root CA Certificates, I have purchased a S/MIME certificate from Entrust and got a ".p12" certificate downloaded to my computer. When trying to export the Public Certificate…
-
Tags for Pages
Hi community Would be possible to add Tags to the Pages? Alternatively, let the Anaplan search box to find Line Item names or text published on the pages. The reason for this is that sometimes the name of the page is not descriptive enough for the number of actions that users can carry out there. This addition will be in…
-
Mapping time when importing csv file
Hello I have an issue when mapping the time when importing a csv file could you pleae help?
-
Hide Background on Grid Cards
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Turning off the background on text/action cards has allowed us to create clean/smooth dashboards, but the backgrounds around Grid…
-
Sprint 3 - 3.5.4.2 Create Distribution Center Capacity Module
Hi, In activity 3.5.4.2 Create Distribution Center Capacity Module formula I gave for Percentage Full is Total Beginning Inventory / Distribution center capacity. But result is greater than 100%. I'm attaching the screenshot. Please help. Thank you very much
-
Need a filter for FY months
Hi community, I need a formula to filter my module months based on current fiscal year. For example, if my FY is 24 (FY24), I want to filter the module to show all months for FY24 (Jan to Dec). After that, I want to show text 'Actual' for actual months and text 'Forecast' for forecast months. Below is a illustration of…
-
5 Steps to Connected Planning Health Check
This article describes how to use health check audit on Anaplan models to identify gaps, deal with data quality, manage user experience, connecting models and user adoption. Based on experience in maintaining and deploying new models across FP&A and operational business functions as the Enterprise Connected Planning…
-
Dynamic Waterfall Charts
Has anyone managed to build a dynamic waterfall chart on a list where the totals are parents and the variances children. In the example below the current forecast and budget are total company and then the variances are shown at regional level, ie one level below total company. I need the graph below to be dynamic for new…
-
Allow no conditional formatting (or transparent) to be applied if the condition is not met
Description of the enhancement required: Enhance conditional formatting so that it will be possible to set the fill if the condition is met but if not, the Grid Style is respected. Currently the conditional formatting is working with a range of values where is set the fill in the left range and in the right range (with…
-
Level 1 10.2.6
Hi, Even if I enter the formula as instructed, it is not reflected. Any help is appreciated. Thanks.
-
Re-Order Categories in NUX
As a Workspace Admin, I need the ability to re-order the categories that are created in NUX. As it stands right now it appears that they will auto-sort to Alphabetical order and/or Numerical order. I cannot always rely on this as sometimes I may use a numbering system for the pages themselves and it becomes confusing to…
-
Level 2 Sprint 3 3.3.5 Activity: Create Inventory Ordering
What does "You can manually select the first week in FY20" mean? It doesn't seem like it's an instruction. I am lost.
-
Level3. Territory>Account module
Hello, I created a module in Data-Hub to transfer the territory>account to Sales Planning model in a numbered format to use as a dimension. However, I am pretty sure that something is incorrect with my module cause all the accounts listed in each territory repeatedly. Any idea what is wrong here? Thanks,
-
Model building activity 13.3.1
Create a Margin Summary Board in My Pages In the Financial Planning & Analysis model, select My Pages from the navigation menu in the upper-left corner. On the My Pages screen, click Create a Personal Page: Page Type: Board Page Name: Margin Summary Workspace: Use the same workspace as your Level 1 model Model: Use your…
-
Level 1 9.2.5 Unit Price %
Hi, When I try to copy and paste this formula I get the below error and cannot seem to work this one out. The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid: Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP:'SYS04 Location Details'.Country, LOOKUP:'SYS06 Product Details'.Product Family]…
-
Event recording available! Modeling tips and tricks
Last month we hosted a challenge inviting Community members to share their thoughts on modeling best practices — over 30 tips were shared! Yesterday, we held an event highlighting that guidance every model builder should know. Jason Blinn (@jasonblinn), Principal Solution Architect and Employee Community Boss at Anaplan,…
-
Level3. Territory>Account module
Hello, I created G3a Territory in Data-Hub rolled up to G2 country. And loaded with Territory Data via CSV file that has been provided in the sprint 2. I created a sys module with a dimension of G3a Territory and Account to create the needed info for Territory and Account# in the Sales Planning Model. However, I see some…
-
Anaplan does not sum the filtered list items but it sums all list items
Is there a way to sum only the list items that I filtered? Now All directions is always the sum of all the list items and not only the list items that I filtered
-
Level 3 Check You Build 4.7 User Story 1.3
Hello , I have already begun with anaplan level 3. im stuck for a week with the next problem. The exercise need to be checked on the next numbers: I have the next numbers: I have the next formula: 'DAT021 PY Revenue FY19'.Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS03 Account>Product…
-
How can I permanently HOLD the TOTAL figure and let the Breakback happen?
Hi Community, Need your help if you have a smart solution to HOLD / LOCK the Top/Total of certain dimensions of a line item which is Breakback enabled! Example screens is given below: So, all I want is to HOLD the yellow circle i.e. 1849 amount and let the below gets change which is 4 levels hierarchy.. We know the HOLD…
-
Loading .csv File issue Numbers dots, commas
Hello, I have an issue when loading my .CSV file, the number I get they are not right: when importing, the system takes the dot from the numbers as being the number not the decimal. For ex, in the CSV file I have 22.2 so twenty-two point 2 and in Anaplan I get 222. Can anyone help with that please? thanks
-
Multiple Models | One Page
We have multiple models, Model A is where user inputs the data, Model B is where the submitted data would eventually sit. Model B receives data from Model A via an action. So once input is done as a user can i press a button (from model B) to technically import data from Model A to Model B. Can we have the action in one…