Modeling

Line Chart Showing Monthly Values for Fiscal Year Lines
I need to create a line chart showing the monthly values for each of several fiscal years as a line chart. The user wants to be able to see lines comparing each month in each fiscal year. For example, on the X-axis would be each month in the fiscal year, January to December, and on the Y-axis would be each fiscal year,…
How to pull the annual total from the month forecast module?
Much appreciate if someone can help with this one. Source module: monthly expense list: cost center & expense type Dimension: time (by month, with year total FY23); version (actual & forecast) Line item: expense Target module: Annual summary list: cost center & expense type Line item: expense, budget, variance, % NO TIME…
LEVEL 2 SPRINT 3 3.3.5.2 Shipping time weeks
For Shipping Time weeks, below was the logic i applied and it went through, however the data i am getting is '0' 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] to further break down i searched for other modules for shipping method dimension but no…
HyperModel: five tips to improve your experience
Are you considering HyperModel for your ecosystem, or have you recently deployed it? Fantastic! We've compiled a shortlist of the top five tips to help make kicking off your HyperModel experience as smooth as possible. Check out these top five tips to improve your experience: 1. Recognize that the Hyperblock has not…
Having more than three dimensions in the pivoting of modules
Hello, Is there a way to have more than three dimensions as rows or columns when pivoting a module? Maybe it is easier with an example, I have to create a report that requires 3 categories on top of the line items, but I am only able to add 2 categories, because the pivoting cannot exceed three dimensions in rows and…
can we have a multi select filter as a page selector in Anaplan?
similar to what we have in excel filtering…can we use page selectors to select multiple boolean formatted line items. Snapshot attached
Ability to Comment Code
The ability to put comment blocks and indents within your formulas, so as to allow model builders to better document and format their code within the models for readability and understanding purposes. This will help align Anaplan's language back to the basic features all other development languages used in an enterprise…
The Key to Aligning Missions at Academic Medical Centers
Disjointed manual spreadsheets are common pain points expressed by our higher ed clients. You may be able to consolidate all academic departments using the same templates on separate tabs, but what if you have a completely separate operating unit with an entirely different model? Or perhaps you have a legacy system in…
3.3.5.5 Update Inventory Ordering to Allow Override of Shipping Method
Hi All, I need some help here regarding the Final Shipping Time in Weeks and Final Shipping Method Graphics attached. When I run this using the default position of Road and a 2 week delivery time it works fin, irrespective of the week I place the order. However, when I choose to Override Shipping Method, pick, say, Air…
Line Item Subset Filter not working in New UX?
Hi All: I am attempting to filter in the NewUX by way of a line item subset. Goal is to hide line items based upon the selection of the user. In the traditional UX I can apply the filter without issue. When I go to apply the filter to my grid in the worksheet (NewUX), it does not allow me to select the line item I wish to…
Planning Gross Margin % and other Ratio metrics at levels above the bottom level
Pretty much everyone would agree that Gross Margin % (GM%) is a REALLY important metric when planning your business. It’s a key performance indicator for healthy past performance, and a key driver for future investment decisions and performance management. Employees are frequently bonused on revenue and margin goals – so…
Community perspective: How to vary model inputs using optionality
Sandi Duffy is a Certified Master Anaplanner and Senior Finance Manager at Challenger Limited. With Anaplan, it is easy to run multiple scenarios within the same model by using optionality. A common use for this would be during the budget setting process. Say, for example, you have a budget model but would like to see what…
Filter not working in UX
I added a time filter for this module expecting the card to populate in the UX. I only want FY23 and 24 as options for selection. It works on the model builder side but the card keeps populating FY22 in the UX despite me saving the view.
Ability to Apply Filters before downloading Model History
Currently, If I want to check history to view some activity on a specific module or list, but I am not aware of the dates when that change took place, It takes forever for me to extract the history for downloading 'ALL' change history and locate that change. I face issues especially when the changes are too many and file…
what is the difference of classic UX and new UX
Community perspective: Anaplan user license management
What is an Anaplan user license? Users get access to Anaplan based on the model role provided to that user. From an Anaplan commercial perspective, each Anaplan user is consuming one active Anaplan user license. On a high level, Anaplan has the following three types of user licenses: * Model builder * Contributor * Viewer…
Application link check from Model
Hi Anaplan, It would be great if we can get a functionality to check from the model as to which all New UX applications the Model is linked to. As if we are working on a MSP model, it gets really difficult to track as the model is linked to which all New UX Apps. Thanks, Shivankur
Summing on Period (Quarter)
Hi, I need some help in summing on the maturity period (quarters). Module 1: no time dimension, standing data showing loan amounts in various currencies, and maturities. Module 2 is dimensioned by time (quarters) and the loan amounts are converted at the quarterly FX rates. Module 3 is dimensioned by time (quarters) and I…
How to prepare for the change to the default Modeling Experience - FAQs
What is happening? The New Modeling Experience will become the default experience in February 2023. It is replacing the Classic Modeling Interface but not eliminating Classic Dashboards or forcing you to use the UX Apps and Pages. What does that mean? Simply, the modeling interface is getting an update to the look and feel…
Calculating the average of a balance sheet item for quarterly / annual totals
I have a number of balance sheet accounts (e.g. Closing Receivables*) for which I need to calculate the average value. This should be calculated as follows: - Monthly: average between the current month and prior month value - Quarterly Total: average of the last 4 data points - Annual Total: average of the last 13 data…
L2 Conclusion - REP05 Local Currency
Is there any issue with the formula for Local Currency? - Although it's fetching the correct result, want to check if there is anything else I'm missing. regards Sudhir
NUX - Pushing Changes from TEST App pages to PROD App Pages
BACKGROUND: We utilize ALM and have everything built out in Apps for End Users. We have Duplicate Apps for TEST and PROD. PROBLEM: This becomes a pain and time consuming maintaining the changes you make in both TEST and PROD. Currently we have to make a duplicate of each page edited, move it to the new app, then repoint…
Quickly duplicate cards on page without having to save them as template
Currently we only have a option to save card as template which is great. But there are many instances where I just need to duplicate a card/grid/etc and not need it saved as a template. Its cumbersome to have to either resetup the grid with specification or to create a template then use and delete it. Thanks!
3.3.5.3 Check Your Work - issue with beginning inventory numbers - can anyone please help!
Hi, my numbers on beginning inventory aren't changing from 13,000 below - Sharing the relevant screenshot incl SYS01 Time Settings By Week - any help would appreciated as why the numbers from beginning inventory are getting referenced prroperly… Also, to add, when I'm changing the formula to IF (…) from IF NOT (..)…
Formula - limiting values returned
Looking to limit the values returned within a module, which I've made a start on the module showing in the right hand side , where limiting by currency. However, if I then also wanted to limit by say GL Category or GL code, how would I go about this? Any help would be welcomed on this
Managing expenses as positive, reporting as negative
we have a client that manages expenses at GL account level as positive numbers. they rollup the GL accounts to reporting lines (they have multiple GL accounts for salary and report salary on a P&L). the reporting lines are hierarchical (total income and total expenses aggregate to profit before tax). they would like to use…
Increase Note Character Count (in Blueprint Mode)
250 characters or how ever many is too small for saving off larger formulas when modeling or if saving detailed descriptions/insctructions. Please increase to a few thousand. Thanks.
Some kind of Bug in model of Anaplan Essential Course for Customer
Hi Community, One of my client users is taking Essential course and notified an issue he got while importing date into transactional data module. See the screenshot below When he clicked to open dropdown to select "Language for month names" (his laptop language setting is Chinese), the mapping window here will collapse and…
Remove the blank space to the left of list items in a Grid View
Hello Fellow Anaplanners, Hope you are all doing great :) While building a dashboard I got struck on something, I am thinking is there a way to remove the blank space which is caused by the parent hierarchy and show the child items at the left. I though you might have tackled this before and help me on this. Thank you!…
Ability to display negative numbers as positives
Detail description of the enhancement that is being requested: We have numerous requests to have costs displayed as positive numbers but aggregate as negative. The current workarounds are very difficult To provide more clarification, could you please explain how you hope the enhancement would assist in your business…

Modeling

Discussion List