-
Facing error in line item name referring in formula
Hi Community, We have been working on copied model and trying to replicate the same line items and formulas as well wherein we are facing an error wherein it is reflecting Line item is not identified line item or list member. Example line item name: Historic range? when we refer this name in formula we are facing error…
-
Date Import not working
Hi All, Need some quick help I want to import a date from 1 module to another module using Import action, however I'm error as "Invalid date" Module 1 - 1 line item (date1) | date format> currentperiodstart() Module 2 - 1 line item (date 2) | date format Now, when I'm trying to import date from module 1 into module 2, I'm…
-
Variance between versions and years
We have a summary balance sheet that is part of a line item subset The request that now had is whether can create a variance report to compare time periods, versions. Whilst I have had some experience of doing this as evidenced below, this has only been when directly referencing a line item subset. The request for balance…
-
creating a new import
How do I create a new import? I have created the Import data source, but now I want to link it to an import. Thanks
-
UX related question!
Is it possible to have the arrow marks as shown in the screenshot below? Like, it should not be a fixed one, it should be dynamic. If yes how this is achievable?
-
Interpolation
How can we do interpolation in Anaplan? I need to interpolate scores from the following criterias: a. Min number with equivalent score b. Max number with equivalent score Thank you!
-
Rate/Balance Variance Analysis
I'm trying to create a standardised way of doing a rate/balance variance analysis between 2 different scenarios (Scenario A and Scenario B) for an output variable to show what is driving the difference. I'd like to be able to select the balance from a drop down and a rate to apply from another drop down and have the…
-
Formating with If statements
I need to format two line items where it is one color when a scenario is true and another when false. There are three different scenarios that can be done: Line A Line B Result TRUE FALSE Line A is yellow Line B is gray FALSE TRUE Line B is yellow Line A is gray FALSE FALSE Both are Yellow Is a nested If statement a good…
-
Can you sum a Line Item Subset?
Just to give some context, we have the line item subset shown in screenshot and this essentially forms a detailed balance sheet before we have any consolidation adjustments. We perform the consolidation adjustments in another module. This module uses the line item subset highlighted above. Then want to be able to pick up…
-
LOOKUP dimensions
I have two modules : SYS REF Public Holidays & SYS DAT01 Public Holidays (Dimension: Time (Year) and Country) I need to display a boolean of delete from SYS Data to SYS REF I created a SYS LOOKUP and I displayed a formula : 'DAT01'.Delete ?[LOOKUP: 'SYS LOOKUP'.ALL pays, SELECT: TIME.All Periods] my look up works only if I…
-
How to apply different logic for parent and child in non composite list
I have a module with countries and time in the page selector and products in row and line items in column. I need to calculate the CM% for my products but calculation should only applicable for (L1 and L2-b). formula will be Rev/CM. I have created the logic with lookup, but that logic is applying only to L2-b and its not…
-
how to start to use anaplan for end user
-
Performance Comparison - OFFSET/LAG/PREVIOUS/LOOKUP
Hi all, Was looking to get some input on a calculation scenario as community pages were a bit vague (or I'm using the wrong keywords). Now, I'm sure most of us understand how Anaplan thrives on being multi-threaded where possible, but when it comes to performing time-based calculations, there's a variety of ways to do the…
-
Can't access my workspace.
Can anybody tell me if Anaplan Workspace is working or not? Actually I can't see my models from level 1 and 2 anymore. And also I can't access anything. I heard that Anaplan Workspace will again be available after 31st March 2024. Is It True? Can someone please tell me?
-
Error Line item for Assignees in Group Task for Workflow
Hi All, I've been working in Anaplan Workflow, when it comes to group task I am facing with a challenge. I chose a line-item driven assignee method in the Group Task, but I was not able to assign the particular line item for assignees. The error showing in the line item for assignees: "There are no valid line items.…
-
Cell counts vary for the same formula
Hi All, I downloaded the Line items from a model I've been asked to review. On a number of instances there are duplications (ie the same formula copied in a number of modules). an example is where the same line item formula is copied 3 times over: Instance A - 3.2M cells Instance B - 600k cells Instance C - 4k cells So…
-
Module Importing through Connect to anaplan model
Dear Team, I am Pursuing My Level 3 certification, I am not seeking help on Modelling But needed a small hint on the import view. I think I am missing something, I try to find the RCA but unable to solve it. Problem Statement- My import view of the G4T List is not coming as expected. Here for each Territory all account are…
-
Bulk Copy Years
Hello everyone, I would like to move all the data in my model by a few years (Write all data from 2020 to 2023, 2021 to 2024…). For that I tried using Bulk Copy, but I can only copy individual months there, not entire years (if I select this accordingly, the button is greyed out). This is therefore a problem, as some…
-
dimensions look up
I have a REF module dimensioned by a list of vacations: this module represents with a hierarchy, a column of start date and end date. (the "vacation list" is a child of "team"). I have a second module dimensioned by Team, which I'd like to model by day, so that I can boolean-select the days off. I've set a formula of :…
-
Move data between Anaplan & SAP
I am looking for possible & efficient ways which can be used to move data between Anaplan & SAP. In the past i have used SSIS to do same between Anaplan & MS Dynamics365/SQL Server, by using Anaplan API to execute import & export actions. Is there a tool which can give me a similar approach for SAP as well?
-
When to use lookup/sum versus when to refer cells in anaplan
I find a little bit confusing on when we would use the lookup or sum function rather than refer the cells in anaplan. Can you help me to explain more about this? I also note that lookup is for looking up non-repetitive value on the source file, while sum is for summing up repetitive value on the source file. Depending on…
-
delete
-
How to flag SKUs based on the lowest revenue
Hi, I have a module Target Setting with 3 dimensions: Brand, Category, Time. Users make an % input to indicate how much each combination should increase Revenue for the next Year. Then, the Target SKU Reduction line item is calculated within the same module to inform how many SKUs should be discontinued to meet the target…
-
Is there a way to reset the List Ids to reorder it correctly?
Hello everyone, I am building a date range filter to allow a use to select weeks and then have it filter to the days belonging to each week. I did this by having a report days being a child of Report weeks and using an Time calc to set up the range. It is working like I want by showing the correct list items. But they are…
-
Complex GL Account Mapping to Cost Centre for Allocation
Hi Anaplaners, I want to mapp certain GLs to CCs and vice versa. Additionally I want to map certain cost centre to all GL Account and vice versa. Based on the mapping I would input an Allocation % for those mapped GL & CC. The mapping is done on the lowest levels of the hierarchy. It will also have the Parent of the GL…
-
Browser Slowness when Model Building
Has anyone else noticed that after 15-30 minutes of model building activity (opening modules, opening lists, updating formulas, opening split views, toggling from blueprint to module view, etc.) that browser tabs slow down and stop responding, and has to be restarted. Been an issue for a few weeks now. Hardware and…
-
Summing a line item with a formula summary method
Hi I have a module that is calculating correctly for each line item when I apply the Formula summary method as its based on the dimensions listed in the context selectors. I need to return the sum of this line item (highlighted in yellow) in another module but it obviously returns zero. I am sure I am missing something…
-
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
-
How to get Range of Values between two Booleans that are time formatted?
When the user select Two Boolean Check the range is defined so I want to get the range of values respective months.
-
Avoiding circular reference using daily workaround to simulate PREVIOUSITEM() function
I'm working on a tops down attrition allocation model. We want to be able to input an annual attrition number and allocate that down to the lowest level (Month, Country, Segment, Attrition Type, and Tenure). Given that attritions have to be whole numbers I've been using MOD() to carry forward the probability of an…