-
Average value
Hi I want to be able to calculate average values of 3 years prior and show them as the value for this year. So, if I am forecasting for May 2023, it would be the average of values of May 2020, May 2021 and May 2022. Please suggest how to achieve this?
-
L2 Sprint 2 2.3.9.1 Import data DATA02 shipping metrics
Import Ignored most likely due to different dimensions. However I don't see anything in original excercise saying dimension should be weekly in the data hub module, please assist ? DATA HUB it is Model calendar year >> Time scale Year In Supply chain this is based on time range. >> Time scale Week Supply Chain Module
-
How to know a parent is selected
Greetings, We have a model where a Employee have territories assigned, each territory have accounts assigned. At the moment if we edit the end date of a territory the end date of the accounts stay the same. So i want to make a formula where if we mark the territory for edition , a boolean on the accounts gets active as…
-
"Sorting an axis with nested dimensions is not supported."
Hi all, I am having an issue trying to sort the column "total orders" of the table below: On the left, first column, are the Units, in the second column the suppliers belonging to that particular unit. The column named "Order Amount (eur)" shows the orders of a certain supplier who has dealt with the unit, while the last…
-
Waking up the model with Cloudworks
Hi everyone, As you know, initializing the model (moving it from disk to memory) can take a while, especially for the larges ones. This can be quite painful for the first users of the day, or for the first one to connect after lunchbreak. I don't find precise or recent informations about it, so here are my two questions:…
-
2.3.9.2 Update and Run Process 9. Import Data from Hub Item 9.1
I am trying to import into the supply chain module for 9.1 for DATA03 Historic volumes. It seems my mapping is not correct but not sure which step it occured. Any idea on how to fix this ? Attachment has full details.
-
Cell count vs. clarity/auditability
I have a calculation module where I'm debating between having more line items so that a future model builder can more clearly understand the math I'm doing vs. having fewer line items to save on cell count. For example, I have line items, Item 1 and Item 2, that pull a value from a data module. Both Item 1 and Item 2 have…
-
Comparing the Total for each element of a list, not the total value of the list
Hello everybody, I've been struggling with a recent dev especially on a specific case, which i hope some you would enlighten me ^^ To Make it short, I have two list : G3 Retail (belong to a hierarchy (G2 & G1) G3 Destination Store (which is a parallel list of the G3 Retail list & is having a top level) Here is a picture…
-
Management Reporting: Hide Empty Columns
Hi Community, In Management Reporting, I created a table with Line Items x Product Category: I have the country as a selector but, for example, if I select a country where we don't sell "Performance" products, it still shows an empty column although I added a filter: Do you know how to hide it so that, in this case, the…
-
Export data to .csv file from a module with page selector and filter is not working
Hi, Exporting data to CSV file from a module with page selector and filter is exporting incorrect results: Sample Data as per my example below, Anaplan is applying the filter (amount<>0) to the first month March 23 only. Zero's are getting exported for the intersections data available in first month (filter is not applied…
-
unable to click from model search
Not sure if anyone has raised this bug already, but when I do a model search in the new modeling experience (which is now the default setting), I get the results but can not click into any of them. Weirdly I noticed that it doesn't open the list/module/db etc. if you click on the name (text area) but works if you click…
-
Size.csv missing - unbale to import the data
Hi, I'm not able to import the Size.csv file into workspace due to the fact that I can't find it into the training or into the Anaplan. Error message displayed: he uploaded file is no longer available; please upload the file again. Can you please let me know where I should find the files? Thank you, Ana Maria
-
how to calculate variance by subtracting actual and forecast budget ?
-
I/m unable to export the custom view from the new UX
Hello Team, I have 1 custom view Grid in the new UX and i'm trying to export the view but it is throwing me an error saying what would be the reasons for the below error, could you please help Thanks in Advance
-
Different formats for one line item
Hi all, A user can input data in the following way: Event type Event Date of the event Is there a way to define different formats for the line item "Date of the Event" on the basis of the other line item "Event Type"? As an example, when I input "Event type 1", the "Date of the event" is Time Period Format, (Type 1, Event…
-
How to map two module data together in order to get inference from it in the third module ?
-
I wanted to subtract two coloumns between a pivot in order to calculate the variance is it possible
-
Build Dynamic YTD/YTG with Non-Native Time
Hey Builders, I'm working on a project which requests a report that requires non-native time due to needing YTD/YTG at the end of each year to track variance on last year's YTD vs current year's YTD. The period to reference in the YTD is to dynamically change as the Current Period is updated within every year, regardless…
-
How can I change the name of the list as a text?
I have a list name 'Group' and it has "city", "state", and "country" as value. Then, I have other lists named 'City', 'State', and 'Country' and those list contains its own items. City = New York, LA, Chicago, Dallas...... State = NY, CA, IL, TX....... Country = US, CA, ...... In a module, I have three line items named…
-
Level 1 Model Building Exam - Model Building Activity 5
I got myself in a little bit of a pickle when I created the in SYS08 Employee Details. I created the Role item as a text format. Now realizing it needs to be a list item format. It will not let me change or delete the item. I am stuck in a pickle. Help! Any guidance you an provide is much appreciated. Thanks! Mike