For example, I want to refer the value of last year july 2022 in current month July 23. the line item is Past year revenue where I just want to show same month revenue from previous year, how could I …
So I'm creating a page in the new UX, essentially trying to display Actual and Budgeted amounts for a period. I'm intending to have the Actuals and Budgeted amounts shown as columns and the different …
Can someone help me debug this, I've checked my SYS01 - Planning Period Filter Weeks. I am sure I am supposed to see the rest of my weeks and not be limited to week 8.
Architect, Builders; Having worked projects with hundreds of bugs, the natural question is how did this happen? The solution passes User Acceptance Testing means that it was adequately tested. This co…
Hi All, I implemented this method (Article below) of dynamic renaming of line items for a customer that require time-based data combined with non-time-based attributes to the same data. It works very …
Hi, I have various forecast versions and a prior year version. I want to do a comparison between the selected version and the prior year version. I am finding that the YTD time summary for the prior y…
So I can't currently can display the Shipping Time, I will attach on what I am seeing. You can slightly see my formula above the screen. What can I do to resolve this bug?
Hello, I just completed all required courses (please see snapshot below), but was not able to download the certificate. Refreshed the page multiple times and waited over half hour, still not working. …
Hi all, I'm trying to create a basic variance report with LIS as a dimension of parameters and the line items to find the variance. But, the challenge here is that the LIS consists of both absolute nu…
Hi All, I'm having an issue with importing a csv file from excel. Below is the column headers that I want to match, the Unique ID and all the other column is what I want as "Header Row". When I make t…
There are two types of statistical forecast models available for in Anaplan - Statistical Product Forecasting model and Monthly Statistical Forecasting Calculation Engine
Hello! I'm developing a Demand Planning Model for school books. Every year, it is critical to update the list of SKUs [both delete and add SKUs] as well as the SKU details [School Subject, School Year…
Hello, I would like to give access to a user so that he can upload himself a CSV file in a module (with a time dimension). I do not want that this user changes by mistake past months. I've done a DCA …
I want to put a period filter like this so that when the user checks the boolean, the data of the months associated with the year will be shown in the below grid. Need some help with this.
I'm creating dashboards for budget owners at my firm. In the dashboard I have a variance analysis module showing budget vs actual. If one of my page selectors is the department (Dev, Sales, G&A) and i…
I'm looking to build a formula that would show the current YTD actual expenses, + the remaining year forecasted expenses to arrive to my FY total expenses. The current model we have set up adds togeth…
Hi, I am building a model which stores historic data of investments/"assets" and reports on them both individually and in aggregate (i.e. the portfolio). I have two Lists. One is called "Assets" and a…
Hello, Is there any way to have boolean line item with a formula and editable depending on the condition? For example: IF Condition_1 THEN True ELSE (boolean editable by the user) Thank you
For example, Amit Kumar joined on 01/01/2020 in the sales department and transferred on 05/01/2021 to the finance department. I made a UX page where user can choose the leave date and the new departme…