Modeling

Custom Time Aggregation
Dear Anaplan Experts, Would it be possible to build a custom time aggregation function while still being able to leverage our system time functions? For example, I am doing some salary calculations at the granularity level of day, then I would like to aggregate the period of 2022-05-25 2022-06-24 to June 2022 because our…
Retreival of Archived Model
Dear Community, I have archived Data Hub Model (Level 2 Sprint 1) , Now I am in Level 2 Sprint 2 (Supply Chain) using Data hub model to pull the historic data, when I importing (Action 9) , I get error saying that source model is Archived by other user . If anyone knows how to retrieve the archive model , that would be…
Setting to restict user from selecting list items multiple times
In some scenarios, where you need the user to map a list item with another list item (one to one mapping), it would be useful to have an Anaplan setting that restricts the user to select a list item only once in the field. Currently, you need to add some manual check to make sure that each item is mapped only once.
Provision to enter data in specific version in Report
Hi, I need to create a report with 3 versions actual,forecast,budget and the data is formula driven. But need to give provision for the planner to override the data only in forecast version which is calculated.Need few suggestions to implement this. Regards, Sri Nitya
Level 1 Model Building Lesson 10.2.5 Employee Names Not Showing
Hi, I have successfully selected the 'Employee # Active?' list subset as a dimension for the EMP02 Employee Expenses Module. However, as you can see below, the employee codes show up instead of their names. Does anyone know how to resolve this? Thanks
L1 MB Certification Test: EMP02 Employee Expenses
Hi- I'm trying to update the formulas to reference the drivers in EMP03 Employee Drivers by role. I keep getting an error when i try to update the formula. Do you know why this error is happening?
IF ELSE statement for different hierarchy levels
Hi team! I have a question about using IF ELSE statements for different levels of hierarchy. I have hierarchy on level 2 (L2) and level 3 (L3). I also have line items which are calculated for L2 and L3 respectively. I need to create a line item on L3 which goes IF *Item from L3* THEN Line item for L3 ELSE Line item for L2.…
Dashboard Chart Settings
Team, I have a customer request to build a report that supports a trend graph. The difficult part is that they want a 3 month comparison chart, based on daily input. So if we are in August and input data August 9th, we will then have 3 trend lines; Line 1 is from the input date back 30 days; the next trend line 2 starts…
No models available
Hi team I had built 3 model, but those are unavailable in my account. Please look into the same.
Parent Child addition
Hi , I need a help in calculation of data at lowest hierarchy level giving values to parent level. For example, l0l1L2DataExpectedFunction usedAa1b11133=SUMIF Aa1b12233 Aa2b2111443 Aa2b2222443 Aa2b2110443 Here, I want values added of all the l2 who has same parent. Can anyone suggest me way out? Thanks, Divya
SUM results not matching up to summary
I'm having an issue with SUM giving me unexpected results. When I'm working with hierarchy lists and just need a top level sum rather than subtotals at all levels of the hierarchy, sometimes I'll use a 1-item list, add a line item set to this list item, and SUM over it to get the top level sum. It's a little convoluted but…
Providing different templates for input based on selection
Hi team, I'm currently working on a supply chain project. We have a use case where we need to provide the user a template to input the attributes. But, the tricky part is not all the attributes needs to be populated for all the products. For example, Let's say for 'Product A' only Attr1 and Attr2 is required in the…
[BUG] Line item format vs value format (YEAR vs MONTH)
Hi Anaplan Devs, I have probably just found an error/bug. Case: 2 line items, one formatted as Period:Month (let's call it LI_A) and second as Period:Year (LI_B) Value in LI_A: Apr 21 (or any other month period) Formula in LI_B: LI_A -1 Expected result: FY21 or FY20 or ERROR (basically if successful then formatted as Year)…
Understanding LAG Function
LAG Definition: Returns the value from the past or from the future based on the syntax Constraint: TIME & DATE Function. LAG will work only with Native TIME. Syntax: LAG(X,Y,Z,O) ArgumentsDescriptionLong DescriptionNatureFormatXValue to OffsetValue to replace with a value from a different time period.MandatoryAny (Number,…
New UX for modeling: refresh dashboard button for classic
As users move to the new interface also for classic dashboards, the "refresh" button becomes even harder to access. Now you have to right click on the tab name to open the tool bar, where the refresh button is. I know that classic dashboards are no longer priority, but this new interface makes it slightly worse to deal…
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…

Modeling

Discussion List