I have (simplified): Actuals Module - dimensioned by Time only Forecast Module - dimensioned by Time and (let's call it) Version List (not the native Version - just a normal list) Settings Module - di…
Hi All, I have a flat list which is a concatenation of Lists - Company Code, Costcenter, Costelement and KPI, ex - IN11_CC2222_CE3333_PL50. There are more than 5000 list members. We already have a mod…
Hello, I have the following problem. I am trying to associate Customer Part Number, which is a unique product code in the customer's store with the SKU that exists in my store. For example, the custom…
Hi, How to forecast data for future months? I have data for FY23 and I want to forecast the Sales for FY24. I have two line items: Sales and Quantity. Is it also possible to forecast the two of them? …
Hello, I have a module with dimension "Invoice Number", in this I have Start Period and End Period for the invoice (it can cover multiple months). In another module without dimensions I want to be abl…
Hi Hoping someone can help me solve this issue I am having. Probably doing something very silly! I want users to filter a list of managers which is a subset of the employee list. I wanted to do this t…
Hi All, I have 3 modules, let's say A, B and SYS Filter A module has dimensions - Stagging list, custom versions. B module has dimensions - Stagging list, subset custom versions. SYS Filter Module has…
Hello, could you please help with following situation. I have the flat list of positions for which Selective access is set (according to the access of the user, so that HRBP of the Facility 1 has acce…
Hi, I'm playing around with some dataset I've found. The data only has values up to the month of June. Is there a function for getting the unit price based on the quantity that I will input for each m…
In the line item "last 3 months sum", I'm trying to sum the last three months. I tried using timesum but wasn't getting the right numbers. Any help appreciated, thanks!
I have a requirement to show the last 52 weeks value. I want to create another line item which has to sum last 52 weeks total hours e.g.: 03/08/2025 should show the last 52 weeks data this should be d…
Hello, I needed to do a rollback on the PROD model to an ID from the History, so it implied to get the PROD from DEPLOYED to STANDARD mode. I knew before that this will happen, but it was kind of urge…
Hello, I have a line item that has a COLLECT() formula. This returns the values just fine. But when I use this line item and Lookup or Select a specific member, it doesn't return any value. Is there a…
Hi All, I'm new to Anaplan and still learning it's way, would appreciate any ideas aligning with best practices. Here's my question: I have a list with combination of properties say products, location…
Users export forecast report every day, they are wondering if the time scale here e.g. "Week 1 FY25" could be "Week 1 FY25 (2024-09-29)" which add a START date of this week, otherwise they have to man…
Hi - I am copying the same formula from another cell, and adjusting the start of the formula to another cell so should be straight forward, but I keep getting 'invalid formula'. Please see screenshot …
Hey little (maybe stupid) question, A couple of months ago, I was able to get rid of the dimensions in a dashboard by clicking twice on the line between the dimensions of the rows and the grid itself.…
Hi, I am facing a challenge with uploading a file, can someone help me? This comes from the training level 1, chapter 8 I don't know what I have to fill in at the forth line option? This needs to be t…
Hello, I'm facing a mapping issue, wherein I've a module with 3 dimensions & few line items- Lets say Dimension X, Y & UID with a line item formatted as dimension ZZ Then there's a 2nd module with the…
Hi Everyone! I know this is still pretty basic but I am still learning the basic formulas and functions of Anaplan. In the first picture as shown below is I derived tons per day: Now, I must consolida…