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 follow…
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…
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 t…
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 underst…
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 T…
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 wa…
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 u…
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 …
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 …
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 …
Hi, I have a daily exchange rate module which store the daily rates for multiple currencies. I wanted to get the last non-zero value for each date for example we have daily exchange rates for 1 Jan 20…
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'…
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 formul…
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 ou…
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 …
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!
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 subs…
Hi, Where can I see the exact model size in Anaplan? I am aware that model size is available as per below image. I am wishing to see the size at a granular level (MB/KB) Thank you.
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 modul…