Modeling

New UX for modeling: Switch between models and keep the module/list tabs open
When using the new navigation bar to switch between models, it would be great if Anaplan can keep the tabs for modules / lists that you have open already. Of course with a time stamp on it, maybe 30min or 1h. So if you go back to that model later, the same modules / lists would already be opened. Ideally also with the…
Getting future years
Hi Team I need to get the sum of values from the next year of current period to rest of our time scale to other module which is not having time dimension. So, for this I am using timesum function. For the entire time period(FY21-FY25) we can use timeperiod(lineitem) logic, but from the next year to rest of the…
New UX for modeling: Dragging column width in modeling screens
Ability to drag the columns to be bigger or smaller on modeling screens, such as blueprint view but also the settings pages (modules, actions, etc). That's especially useful for the second tab "Imports" on the Actions setting page. It's currently impossible to read the content when we use saved views, and there's no…
New UX for modeling: Formula tips
In the new formula editor, it would be great if we could get formula tips, similar to excel that gives you a cheat-sheet of what arguments are needed and in what order. So instead of having to open an Anapedia page everytime to remember the order of the functions I use left often, this would pop up when I start typing in…
Concatenate values
Hi guys, i would like to know if its possible to concatenate values like this to create a code: - i have three line items : Year; Currency; Group - the final output i want for my code is : TypeYearCurrencyGroup i dont want to add a list or create a manual entry for 'Type' because it will always be the same since there is…
Avoiding a Circular Reference
Hi, Having a problem avoiding a circular reference when it comes to this Anaplan Formula. The circular refence comes up in the Line Item's "Excess Funding Sweep" when trying to make equal to the "Calculated MCA Sweep to Excess Funding", because the "Calculated MCA Sweep to Excess Funding" references the "Securitization…
weekly Time set
Hello,please help me. Start time is the first Monday of each month. Daily data are expressed by week,How to set the time? for example: input:5/1 100,5/2 200,5/3 100,5/4 200,5/5 200・・・6/30 100 want to output :May week 1 = 5/3(Mon)~5/9 week 2 = 5/10~5/16 week 3 = 5/17~5/23 week 4 = 5/24~5/30 week 5 = 5/31~6/6 June week 1 =…
Quarterly Totals in Months
Community, In my module for forecasting salaries, I want quarterly totals in months (see attached) to be used for Superannuation calc. But I want to achieve it using MOVINGSUM (or similar) based on a "Pay" line item which resets after every 3 months. Any help would be greatly appreciated! Thanks, Shubham P:S: turning on…
Format Column for List Formatted Line Item in Module Blueprint Export
When we export module blueprint to a file, list formatted line item has the list ID as value in the Format column instead of the name of the list itself. It will be useful if the list name is also added so that the exact list used by a specific line item can be known more easily without referring back to Anaplan blueprint.
Restrict Time dimension based on User Selection
User will select boolean for Q1,Q2.... or H1 or FY21 etc using boolean only 1 selection, Need to filter module view with with dimensio L1, L2 and time to only the selected time view. Tried many ways, could not able to show H1, H2 etc without Quarter selection as they are summary items. Thanks in Advance
How to calculate the cumulative value without using the CUMULATE function
Hi everyone. I would like to know how to calculate the cumulative value without using the CUMULATE function. Please refer to the Excel diagram. I would like to put FORMULA in the LINEITEM of CUMULATE. I would like to avoid using the CUMULATE function if possible, as it degrades performance. Best regards,
What is 'Is Organization' in List
Hi Everyone, I was hoping someone could explain to me what is the purpose of 'Is Organization' column found in the List and since this column is greyed out I would like to know how we can untick it?
Level 2 Sprint 1- 1.4.3.2 Import Data & Add Formula
Hi, I'm stuck with the activity mentioned in the subject. When I try to add the formula for the Code line item it throws an error(PFA Screenshot). Also, can someone please help me with importing the data correctly? PFA Screenshots. Not sure what I'm doing wrong. Thanks in advance.
Volume Entry Worksheet - Training issue
Hi Experts, I am building the worksheet and in the output worksheet, I am missing the Year Total for some reason. I went back and looked at the 'REV02 Volume Inputs' and its looks good. Even when I added this grid to this worksheet, I am getting the summary of the months as FY20, FY21, but when I apply the filter as per…
Level 2 Sprint 3
@JaredDolich I have a question about selective access. I built the Stock Exception UX page and then continued to building the roles within Sprint 3. I added selective access to my P2 list for one of the roles. I was going back into my Stock Exception UX page to look at something and I don't have any data because it says my…
Snapshotting Issue - Formula Summary for Time Periods
Hello! We are doing snapshots for some key metrics, and I'm facing an issue where a few of the source line items are %ages with a Formula summary for Time period. When these are being imported into the snapshot modules, the quarter value is being messed up because that can't have a Formula summary. I figured I could create…
Open the saved view if you save a view
When creating a saved view, it will not open by default, but you need to open the saved view in order to finetune it. It will benefit the model builders, because now a lot of times you create a saved view and you need to remember to open it again before making more changes to the view and continue saving. A lot of times…
Changing switchover is giving circular references error
Hello - I'm trying to move forward the switchover date for 1 version in a model and I'm getting a circular reference error message. This is the first time that this has happened. Any ideas what would be causing this / how to fix? FYI - the error message shows a giant list of references that it says are impacted. Thanks,…
Model Settings, and lesson 13 help
Does anyone know how we can access our model the way we have been doing this whole time? I have attached pictures of what my model looks like when I log in, and where did the versions, modules, etc settings disappear? I've also circled that under View, there is no save option like there was yesterday? How do I complete…
OFFSET v LAG v LEAD
Hi All, I understand each of these functions but could someone succinctly explain the difference. I would naturally lean towards using OFFSET when looking to pull and push data from different time periods so I have never actually used LAG or LEAD in a live build. Where would LAG or LEAD be used over OFFSET?
Help Level 2 Sprint 3 - Access driver set up for Product replenishment dashboard
Can some one help me identify what am doing wrong here My formula for Override Amount looks right and aligns with description but am confused on the highlighted piece. Please see my formula and description below. Override Amount – Write? : 'Submit Purchase Order - Write?' AND 'INV01 Inventory Ordering'.Submit Purchase…
Optimizer functionality
Has there been any discussion on incorporating multi-objective linear programming in the optimizer moving forward? I'm trying to find a way to incorporate soft constraints into the current optimizer but haven't had any luck. Thanks
Enable placement (Before, After, Top, Bottom) of new module upon Insert of module.
Similar to the drop down list when adding a new member to a list, it would reduce steps if I could add the new module to the Bottom of the display or After a selected module. In order to list modules sequentially, eg. SYS01, SYS02, SYS03, I must insert the module, then go back to the modules list and Reorder.
TEXTLIST over USER-list
Hi all, They TEXTLIST-function isn't allowed over the USER-list while this would be helpful in some cases. Can this be altered? All the best,
New UX Idea - Show History while drill down
New UX is missing one useful feature presented in classic. Show history while drilling down is available in classic. But not in New UX:
Move values from flat list to hierarchical list
Hello, Everyone! Please, help me to solve the issue. I have a Flat list with the -1 and 1 values. I have a Hierarchical list consisted from the same code from the flat list but in the hierarchy. There are more than 15 levels. I want to assign every -1 or 1 from the flat list to every element in the hierarchical list. The…
Level 2 Sprint 1 1.5.7.3
Hi Team, When reviewing 'Check your Work' my output is similar with the exception of the dimension at the top. Check your Work in the content section has no time dimension at the top only 'Has Data'?. My output includes a date, namely the relevant week. When I try to omit a time dimension, in this case 'week', I'm unable…
I want to find if a List item is present in a Line item(formated as earlier List) in a module
Use Case: Users enter values in a module M1 with dimension Project P1. They also enter their name in Line Item LI1 formated as ListUser L1 for projects they update values. Now I want to find with boolean in ListUser Module M2 whether they entered any values or not. So I need to search in LI1 in M1 and return true in M2 if…
Native Version Filtering
Hi, Is there a way i can add the native version that has formula in my filtering ? See example below, i need to activate the boolean in my "Act vs FC" version. Thanks in advance for helping. Regards, Tom
Level 2 Sprint 3 AD02 query
In Level 2 Sprint 3 I have the following formulae for the boolean line items in AD02 Submit Purchase Order - Write?'INV01 Inventory Ordering'.Submit Purchase Order Request?Override Shipping - Write?'INV01 Inventory Ordering'.Override Shipping Method? AND 'Submit Purchase Order - Write?'Override Amount - Write?'INV01…

Modeling

Discussion List