-
YTG & YTD Calculation by using custom list
Hi All, I've one use case where I've create list which includes YTD & YTG as list item. Then I've create a mapping module between Time & YTD & YTG list item as shown in below screenshot. But when I am using sum to get data which is dimensioned by YTD & YTG List, result is showing 0. Can anyone explain why I am getting 0…
-
Lag inside an If statement , best practice?
Hi I need to put a lag function inside an IF statement. What is the best practice for this to optimize model performance? Should I break it into to line items? Or would it be more efficient to do: IF NOT x > y THEN 0 ELSE LAG() ? Thank you
-
How to lookup transactional data without having many-dimensioned calculation module?
I have a module that contains ledger data and includes information such as suppliers, produts, departments and ledger mappings as well as the cost/income on a monthly basis. I want to create a module that end users can input into for their department where they're entering details for their next year's budget. For this,…
-
Same line item to be editable and formula based
I have one line item and I need data to be formula based for first 5 years (Already defined in a sys time module) and next 5 years (i.e future years) to be manually inputted. We dont want an extra line item for that editable part. How can I do this.
-
Displaying Total but not the underlying Items
Hi all, i have an unusual demand regarding a dev, I am asked to display the value of a parent but not the childrens value, however the items are displayed. Basically, i have a Hierarchy that goes from C1 to C5, but the focus here is on C4 and C5. I need to do something like this : The "A" Parent is on C4 Level, and the…
-
Want to make an action card that allows me to insert new data into a list
want to create an action card for a list lets call it user list ( Numbered List). I want to make an action where i type in a new name and it makes a new entry into said list. I thought Create Actions should work but they dont seem to apply here.
-
Running alternate hierarchy
We currently run the following hierarchy within our system This works for how the business currently reports, however in the future will need to still be able to report in the above hierarchy but then we would also need to report in the following structure. As you can see the bottom level would be the same, however I would…
-
How to create filter in Multiple axis rows and columns at the same time
I need the user to be able to filter the combos in the rows. For instance, when they select combo 1, the time dimension in the column should display with non-zero values corresponding to combo 1.
-
Summing Previous and Current Weeks Open Orders
Hello, I am looking to write a formula to incorporate orders that were placed in previous weeks but are left out of current week. In the example pictures, the current week has 312 units open, but the current open from previous weeks and current week is at 10,056 units. The residual is not included in my module is throwing…
-
Splitting single line item into multiple line item
Hello Team, As project requirement I need to split the total annual amount into month wise and under different heads. I have created one input model where end user will input the amount. expected output is as below Amount will get spit based on certain rule defined. I am clear about the calculation of amount and output…
-
How to create a Filter Of Time based on a combo with different time
Here i want to have a time filter based on the combo . Where user filter highlighted(Red Colour) year . then dynamically the time filter should be applied 2025 to 2026
-
How to get around circular reference with an average?
Hi all , I have been having trouble with this problem. I created a simplified example of the issue. I have a daily module. First I must manually calculate the Average balance with the sum & average line item because I only want the average to be calculated with "Working Days" (not holidays and weekends). (I must select all…
-
Incorrect % line item summary
Hello Everyone, I've a list with 10 members where each member has a value of 10%. The summary for this line item shows 0.999.. instead of 1 in the backend. When I'm comparing the summary with 1 it gives me incorrect value. Does anyone know the reason for this? The summary is correct as 1 when the value entered is 50% for 2…
-
Make one list as parent of a different hierarchy list
I have a concatenated list P5_L5 that is rolling up to P4 list. Now I have created a system module with P5_L5 list and defined P5_L5 name, code, P4, P3,P2,P1 as parent. Then defined L5 using Finditem and then added L4,L3,L2,L1 as parent of L5. Now I want to create a list where P5_L5 can be assigned under L5 (L5 as a parent…
-
List Subset best practices
Let’s say I have a list, “List A”, and I have a list subset called, “Subset 1”. I have member 1, 2, 3 are part of the subset. I have created a system module where I can import into the SS. Can I import true into record 1, 2 and false for 3 to remove it from the SS?
-
How to Efficiently Manage Version Control in Anaplan Models?
Hi everyone I've been working with Anaplan for a few months now and am getting more comfortable with its functionalities. However, I’m facing some challenges with version control in our Anaplan models. We often have to make updates and changes, and ensuring that these are managed efficiently without disrupting our live…
-
I need to add two lists of same hierarchy in a module dimension
here Abc and Xyz is a part of P2 list Abc1,2,3 and XyzXyz1,2 3 is their child P5 level respectively. Now how can I add both the lists in dimension in such a way iit will show only their respective child's I have created a list where I defined P5 and added P2 as parent and updated from a System module where we defined P2…
-
ISFIRSTOCCURRENCE not providing the correct result
Hi Anaplanners, I was trying to setup a simple isfirstoccurrence formula and I couldn't get to the correct result: In screenshot below, I have the module dimensioned by #P3b_Child Territory, which has a parent. I want to use the isfirstoccurrence formula to only show true for the first appearance of "Americas" in the LI…
-
Is there a way to get a timestamp automatically added to an export file name
It would be super helpful to have the timestamp as part of the export file name in Anaplan, especially when clients run reports every day during the budget season. Is it possible to do? And do automatically?
-
Boolean oriented Show/Hide & Variance
Given a module which has Time(quarter) dimension, Total $ (line item), Scenarios(list, dynamically user created). On a dashboard view, how can we let user choose which Scenario they want to see based on boolean and create variances of selected scenario?