-
how to do provision payout id generation in anaplan model
-
Xlookup in Anaplan
Background: have a strange 2-level hierarchy where items are at the top level if they have any children, and they are at the 2nd level if they have any parents. I have many items that exist at both the top level and lower level of the hierarchy, up to 5 levels deep (but only 2 levels ever show up in the parent to child…
-
How to apply conditional formatting based on total?
I have a module dimensioned by L2 SubFunction list. I need to apply conditional formatting based on the total of all functions(ie., L1 Function summary). If all functions =100% green else red. How do I do this given that all functions is not a line item but the L1 Function summary.
-
Sample Reporting
Good Day All I m looking for a sample report template on the assessment of incorporating two models into one ( like workspace optimization, impacts, and advantage ). Can anyone help to share the same? Thanks in advance.
-
How can i get the crossover by function
Hi , As per the screen shot, in the left grid whenever i select the y the the left grid should show the same year start month and end month and if i select the y-1 ans week 44 the value then the right side grid should show the 2022 and 44 the week month +1 year how can i achevie this in a simple way
-
How to convert Month to year (Ex: Apr 22-Mar 23 to FY 22as year)
Hi Everyone, Is there any method that we can convert month to year, as i have scenario like timescale was APR 22 to Mar 23 as text formatted line item and we need to get a time period format as year and value would be as FY 22. Any Advice. Thanks
-
How to update cell values based on different criteria
Dear all, First of all, thank you all for all the support you provide here. It has been very useful in my training journey. Now I am working on a report where I have to put data based on % value, so the total % is in a line item and in new line item, I am trying to rank it based on %. I am trying below formula, but it…
-
How to merge two models into one?
Hello Team, Would like to check on the following : There is Product standalone report exists in two models. I would like to merge into one model for space optimization. what are the steps to be followed? An leads or advise on how to proceed this? Thanks in advance.
-
ALM | Unable to sync | Error occurred "Sorry, null has been deleted"
Hi Anaplan Team, Good day! I would like to seek for your assistance to identify the cause- why we are getting the attached error in Anaplan and on how we can avoid getting this error while syncing. Thank you so much! Rachelle
-
Error when changing list dimension to subset
HI, I have a list as dimension in one of my modules, and I am trying to change that dimension to a subset of the same list. However, when I try to do that, I get the following error message; "To serve as an access driver, a Top Level Item must be present on any line item dimensions that don’t match those of the target…
-
Dynamic Cell Access
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
-
Using numbered transactional list vs. normal list with unique id (concatenated)
I came across a model where all the transactional files are loaded into a numbered list, using the combination of properties (like period, cost center/profit center, company) for uniqueness. I understand the best practice would be to load these files into a flat list, using a unique id which, in this case, would have to be…
-
Multiple information columns prior to Time Periods columns
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…
-
Filer Q and Year, to Calculate line items
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…
-
Anaplan count function
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…
-
Stress Testing on Anaplan ICAAP/ICARA
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
-
Data Hub to Spoke Model Performance Question
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…
-
How to add boolean as true above intersection of same month
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…
-
Time Range replaced by Model Time in Pivot View
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…
-
Model builder keeps clearing cookies in Chrome
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…
-
Saved view different in Dev & Deployed - same revision tag
Hello model builders! I'm running into something I don't understand; it appears to be a bug though I'm not sure. We've got a specific saved view that does not match between our dev. & prod. models. I've tried to override the saved view, then pushed a new revision tag (it contained no changes). Dev. Model Saved View:…
-
Send Email alter or show alert on screen remind
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
-
Formula help on finding a % of a Calculated LI
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…
-
Combining the count of two list items.
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…
-
ALM - How to LOOKUP native Versions
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?
-
Total number of Archived models in Workspace
Hi team, Is there any limit of archived models that can exists in the workspace? Any links/articles will be appreciated..!! Thank you, Shraddha
-
Filter on line items that contain a specific text
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!
-
Anaplan Level 2 sprint 3 INV03 formula showing up as blank
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…
-
Count line items
Hi, I am looking for a way to count the number of TRUE items for a Boolean formatted line item. As per above image, since 3 of the Booleans are selected, I need a mechanism where I can get 3 as the output (it could be in different module as well)
-
Subsidiary view Data
hi Team, I have text lineItem (Role change from ASN) and second linitem (Role ID for ASN Role) applies to subset, I have a boolen value (Bu role?) that need to be true if text value is present in subset. adding my three fields below. formula written not working as expected. Any help appreciated. Thanks Jerin
