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) ArgumentsDescriptionL…
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 …
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 30mi…
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…
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 "Import…
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…
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 : TypeYearCur…
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 "Calc…
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 …
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 …
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 add…
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, …
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.…
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?
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 d…
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 ad…
@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 t…
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 th…
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 …
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 …
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 se…
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 per…
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 descri…
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 b…
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 …
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…
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'?.…
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 bool…
