-
Is there a way to export a module into excel with each line item on a different tab?
I have a module dimensioned by time and a store list, with cost lines as line items. I'd like to export into excel with each line item as a separate tab. We don't have widespread use of the excel add-in so I'd prefer a way without needing to use that if possible.
-
Using Maps and the Longitude and Latitude seem to be out
I am mapping volume using the new Marker layer in maps, and have all the 'correct' longitude and latitudes for UK Postcode regions. However when I add these as a layer, ALL of them are out of place (to the right and above where they should) so some end up in the sea. The top red circle is supposed to be York ( The latitude…
-
Anaplan calculates 0.000000000000000111022 value but it should be zero.
Can someone help me or point me to if there are already discussion around this topic? In Anaplan, I am doing a moving sum prior 11 months and it looks like it returns a 0. As seen in the screenshot for Sep 23. But when I copy and paste the value into Excel, it is showing 0.000000000000000111022. Copied SEPT 23 into in…
-
Text to Column feature in Anaplan
Anaplanners, Is there a way we can convert a text to column like how we do in excel. Example below: You can see Column A (member name) and Column B (Projects Involved/textlist). Using Texts to Columns we can convert column B dynamically to different columns. As its dynamic some members have 3 projects while some may have…
-
Nested Graph & Graph/Chart color based on value
Dear Anaplanners, I'm stuck on this particular case wherein Is it possible to get nested graphs ? Any workarounds, i did see them posted in ideas exchange. Secondly would like the graph to have a dynamic color scheme based on the values. Example: Refer below table, 4 teams, each could have dynamic members and each member…
-
Puzzled by a CUMULATE formula...
Hi All, I've picked up this formula at work, and I simply do not understand it. The formula is for the line 'Switchover month', and reports a '1'. IF CUMULATE(IF Switchover THEN 0 ELSE 1) = 1 THEN 1 ELSE 0 'Switchover' is an unticked Boolean, The actual month is October in a FY starting in January. I get the CUMULATE…
-
How to get the value in between native dimesion
-
Date Line Item using Min Summary
Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO
-
How to set up action that will change the boolean (in form of tickbox) for selected periods?
I have a module that contains Cost Centers and Accounts and time dimensions. When user unticks a box called Override (line item), the values for combination of Account and Cost Center will be automatically populated using last 3m average values. If the box is ticked, then user is able to manually submit their own number…
-
How to make a user-accessible history
Hello! :) Is it feasible for the user to store and access previous versions of a module directly in Anaplan? This concerns the module SKU details that the end user uploads at the start of the year. There are usually a few errors or corrections made in the first few weeks, and I would like to offer the user the opportunity…
-
Not able to Insert multiple Items on a worksheet
Hello fellow Anaplaners, I have set up a worksheet (tenancy schedule). I have no issues with right clicking and inserting multiple items. But for my client, the option is greyed out. He is not able to insert List Items. What I have checked so far: -Numbered List: Production Data checked -Editing on worksheet is enabled…
-
Hi Everyone, I am reaching out to the community for some help with a formula.
I am looking for a way to automate the Batch Index column with a formula. Any help or advice would be greatly appreciated! Thank you!
-
LISS with formulas
Hi, I have an issue where if I use a LISS to collect a line item that has a formula summary, it sums the line item for the time dimension rather than adopting the formula. Any assistance would be great. Thanks in advance.
-
User experiencing an odd issue when extracting the volumes in a model.
How can I turn on the setting “Use digit settings for unformatted exports” for the export Export Volume report “Export Volume report by month, distributor and NRS”? It needs to turn it on for any csv extracts in a model.
-
Data load from one module to another module
Dear Experts, Is it possible to load one module with contains lists(time, country, customer, products and line items are actual price and selling price) to another module (all lists except country) How to use lookup? Suggest me some mapping, please?
-
ALM Question - How to setup Imports and Import Data
ALM Newbie here. Implementing my first ALM for a model. I understand the difference between Production and Structural data. I have categorized my list as production vs structural data based on my understanding. I currently have some import actions that loads new members to my production list and load data into data module.…
-
RANK within Multiple Hierarchies
Hi, I'm trying to use the RANK function within a Module with multiple dimensions with hierarchies. As explained in Group option in RANK Function by @DavidSmith I've created a Group By list but however when you're on a parent in a hierarchy this 'Group By' line item will result into blank. Changing the summary method to…
-
System generated Number List not properly syncing from DEV to PROD
Hi All, My data source is unable to provide a single unique Key to act as a List Item, so I have a system generated ID as the list with a concatenated Key columns into a single column to make it unique (Numbered List). My issue is when I sync the DEV to the PROD and do an import in DEV everything works fine but then when I…
-
Store Module Versions
Hello! :) Is it feasible for the user to store and access previous versions of a module directly in Anaplan? This concerns the module SKU details that the end user uploads at the start of the year. There are usually a few errors or corrections made in the first few weeks, and I would like to offer the user the opportunity…
-
How to convert module line item into a list?
I want to convert module line item "WBS" into a list? The formula of this "WBS" as line item as follow: 1.) CJI02. CJi3 for Phasing Report (Module). WBS = CJI01. Transactions Data'.WBS Imported 2. CJI01. Transactions Data (module) WBS Imported = 'CJI3 Transactions'.Object 3. 'CJI3 Transactions (General List) =CJI3…
-
LAG function - date format
Hello Anaplan Community, I've encountered an error message that's been causing some confusion for me. I'm sure I'm missing something crucial with the LAG function, and I'd greatly appreciate your assistance in resolving this issue. As far as I understand, the LAG function in Anaplan is used to return values from a prior…
-
Year to go calculation
Has anyone worked out a Year to Go calculation (amount of spend that is left in the year)? I thought it was as easy as YEARVALUE(Amount) - YEARTODATE(Amount) But this doesn't work on a versioned line item with a switchover that happens during the year. Full year for the actuals part is different to full year from the…
-
Can't open models
Hi, I just Anaplan access. However, I'm not able to open the models sent to me. I saw them when I first got the access, but not any more. Does anyone have similar issues? I generated a ticket through IRIS but no one was able to help so far. Thanks.
-
DCA on a certain user Function
Hello, Need your help with a modeling formula and DCA: i have Boolean A - when it's checked , you can't override it. Boolean B, when it's checked, you can override it with Boolean C. My check on Boolean C workes fine : it gets checked as I want. The issue is that, when going in the UX, even if Boolean C is checked, I…
-
Optimizer - Approach
Hi All, I am trying build optimizer for assignment of products into lines. Below is the scenario: 1) calculated the capacity of each line ( Dimension by Factory Lines) 2) Created Production plan for each SKU ( Dimensioned by SKU) 3) Then Have a mapping module between Factory lines and production which helps to decided…
-
Forecast Function in Anaplan
Hi team, Can i know if we have an equivalent function for forecast() from excel in Anaplan. In Excel we have Excel FORECAST function The FORECAST function in Excel is used to predict a future value by using linear regression. In other words, FORECAST projects a future value along a line of best fit based on historical…
-
Limiting user edit access to column in a module?
Hi, I am trying to create a DCA to control access to editing 2 columns in a module by specific user. The modules are accessible by 2 roles (Planners & Category Managers). Currently both roles have write access to the module. However I want to restrict the Category Managers to be able to edit only 2 columns in the…
-
Boolean dependent selection with DCA
I am trying to find a solution to my module : I have 3 booleans Boolean A Boolean B Boolean C The Booleans B and C can be selected only if Boolean A is selected. I have used the DCA for this. The DCA is a simple one : A. The DCA is applied to B and C. My question is : when I deselect the Boolean A, the Boolean B or C that…
-
LiS for Export module
Hello Comunity, I am trying to build a LiS on order to have a selection of the Forecast and the Type of the FTE. The problem I have is that when I try to build my LiS on my Forecast Model, the FTE Type is a subset List put in pages. So I won't be able, in my LiS to have the Forecast by each FTE Type(the selection is not…
-
User List in PROD and Sandbox models
Hello, I have a production and sandbox model in the same workspace, and I realized that when I delete or add a user to the sandbox model, it is also added to the production model and vice versa even though there is no sync or connection between the models other than they are being in the same workspace. How is that…
