Modeling

Hi, Can somebody please help me with this formula?

Hi, The dynamic Cell Access - learning app doesn't show in my Workspace although I have download it three times. Please guide me. Thanks, Mark

In the following article, I would like to discuss a common case of model building: the LOOKUP function doesn’t work with summary elements of hierarchical lists. Among other things, this forces model builders to use SELECT and not configure Production Data for some lists. I want to present to you an alternative approach.…

Hi @JaredDolich i Have stack with how to update the formulas for my Line Items in my Module EMP02 Employee Expenses. This is the formula i am using IF Employed? THEN Salary * 'EMP03 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 i have read other…

One of the Product Supply Manager user stories for this sprint included the ability to override suggested order quantities. Update the INV01 module with additional line items to provide this functionality. In the INV01 Inventory Ordering module, add the following line items: Line Item Format Purpose Override Suggested…

The process of designing a model will help you: * Understand the customer’s problem more completely * Bring to light any incorrect assumptions you may have made, allowing for correction before building begins * Provide the big picture view for building This process includes the following steps: * Understand the…

Hello, I have an interesting challenge I am trying to solve. Background: * We have 4 Forecast versions. * Version Forecast (3+9) means that the forecast has 3 months of Actuals and 9 months of forecasted data. * Actuals data is loaded from a source system. The Challenge: How can we ensure that all data in the Forecast…

As an architect, I would like to have the ability to add bolded headers directly within the modules contents panel to separate a model's modules. Currently this is accomplished via empty modules with delimiter based titles. For example an empty "------ Systems ------" module created above all SYS modules. Having the…

Is this right?

Hi, Asking for some general advice on how best to manage this. We have several schedules in Excel which show mutliple information columns prior to the Time Period Columns. Eg. Project Name | Project Type | Product | Start Date | End Date | Jan 22 | Feb 22 | Mar 22 | Apr 22| etc..... There are several tables like this that…

Hi All, My issue is that I'm using a graph to show the P&L, but my 3-year trendline is spiking, when set to Q and Years. So I have P&L line items calculations and they are connected to different module views, so I created time filters modules to calculate the Periodic, Yearly, and Quarters. So, if I change in the line…

Hello Anaplan Community, I am stuck in counting the items in a line item. I have a line item called 'Status' and it is List formatted. Now I want to count the number of Particular items in the line items. Like 'Completed' occurs four times, so it should count completed as 4.Like wise 'In Progress' occurred four times, so…

Hey Everyone, I'm just wondering if anyone has tried to use Anaplan for stress testing? How did you go about it and was it advantageous to use Anaplan over something more flexible like excel? If it was advantageous how so? Thank you, Padraig

We are building a budgeting and reporting model based on transactions incorporating our chart of accounts. We have built a Data Hub to house the lowest level transactions. Currently we budget using 6 categories with several layers of hierarchy totaling a count of 6,475 items. Summarizing monthly transactions we are looking…

Can anyone explain why I'm not getting the view as displayed in the instruction? There is no check in my view? Thanks,

Hi Everyone, I have a module with 2 dimension & 1 Line item. Dimension 1 - Anaplan Month time (In columns) Dimension 2 - Time List ( In Rows : Similar to Anaplan time month) Line item name - Boolean up true. In Time List , I have 5 months: Jan 22 Feb 22 Mar 22 Apr 22 May 22 Now , please see the attached Image. The way you…

Hello Everyone, We have applied a time range of "Current Year" to a module. However when I open pivot view of the same module, we do not see this, instead we see the full model timescale applied. (Consequently, a filter applied to a NUX grid based off this module is now asking for a time selection. The filter line item has…

Hi everyone, I appreciate any help that can be provided, I was very stuck on the formula for Shipping Method. I was trying the formula below and getting error "Format of mapping used for lookup doesn't match any dimension of the source". I believe I am using the correct module line items, but am struggling to understand…

Is anyone else experiencing issues with Google Chrome constantly reverting to the classic model building UX whenever you open a new Anaplan tab? I don't have any specific cookies settings for Anaplan in my Chrome settings, and I've noticed other model builders experiencing the same issue while on screenshares. Seems that…

I'm working on a cycle that will end when the end date is specified. I'd like to send the email 10 days before the deadline. Also necessary to display an alert on pages in order to check the end date and next cycle data. Is there a way to do this in Anaplan? @Sravan @prabhu

Hi, I'm trying to create a formula where it will create a % based on taking my States List parent by each individual state. The formula I have so far is Total Collections / Total Collections[SELECT: State.North America] . I feel like this is correct but my percentages are not looking right. Please advise. want to take this…

Hi All, So we have a list say Project phase with three list items in it: Project phase> ALL - Design - Implementation - Done This is how page selector in dashboard looks like and the data tables also represent the values when we based on the list item we have selected. But now the business has requested to combine two list…

Currently, using SELECT statements in formulas for native versions - Actual/Forecast. But, this will not work with ALM, so what should be an alternate approach for looking up native versions in formulas with ALM implementation?

Hello, I have a module with many line items, and I want to filter on all line items that contain a specific word (e.g., "home"). How can I do that? Thanks a lot!

Hello, For the line item "Stock Exception", here's the formula I wrote: 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution Center] However, if I select "All Products", it is showing up as blank. Is there an error in my formula? How should I…