-
How to connect my list to module for filter
Hello everyone. i would to seek for your assistance on how can i connect my list to module for filtering. i have a list which has Soft Opening, Pre-Grand Opening and Grand Opening in my module i have the details where i can input all the details of the contract including Opening Category. i created a new module where i can…
-
If parent is numbered list is it necessary for child to be a numbered list
-
Adding hierarchy using a boolean
Hi, I have a list hierarchy where till level 3 we have imported and now for Level 4 and 5 we want to get a checkbox that will say Relevant data. Once I will check that and click on Add to Hierarchy Level 4 and subsequent Level5 will be created. Level 4 have a fixed 3 items that gets added to all Level 3 items as a child.…
-
Level 2-Conclusion: Import Shipping Expenses into OTH01 Module
Hello, I am trying to import data from my Supply chain model to FP&A model however, I am getting some errors. Here is the source module (from Supply chain model). The timecard is "Month" for shipping cost And here is the target module (from FP&A model). The time card is "Month". I am trying to import the shipping cost data…
-
Level 2 Sprint 1 1.1.5 Activity: Download Copy of Data Hub Model
I am trying to import the model in the Anaplan application which Calendar property should I select I am confused. Can someone help me with the same?
-
Best Practice to combine two or more model data into one output model
Hello Team As project requirement I need to combine information from two different model (i.e. Actual Payroll information and Plan Payroll Information) In different model have calculated this information since calculation is different and in plan payroll end user will make the changes. List used in both models are number…
-
Select data based on Month
Hi, I have data spanning five years, and I need to filter it to extract information for a specific three-month period within one of those years. What is the best way to do this?
-
Hierarchy Mapping from flat list
Currently we report our P&L using list Entity L2 which contains all our entities as a flat list. We want to create a new module that reports the same P&L information but not on a flat hierarchy. The dimension of this module is New Hierarchy L6 which rolls up into our highest consolidation level (TopCo) This is the mapping…
-
Synchronizing count for two (or more similaire items )
Hi All, i have been wondering if it was possible two synchronize two items for a count. Here is the case : We have a person called Williams Peter A1 arrived at first is the "Centre de coûts" (Cost Center) called TestCC1 in 04/01/2024 as we can see with the Date d'import. But along the way, he changed the cost center to…
-
Dealing with monthly Dinamic Hierarchies.
Hi, I would like to hear from the community if you have dealt with the same issue that I have and how you solved it. The issue is as follows: I have 2 lists: Cost Center (with selective access enabled, so an owner can access only one Cost Center) Employee (Employee is a child of the Cost Center list) The problem is that an…
-
Year-on-year growth rate
I have a line item 'Revenue' with monthly data. I'm trying to calculate the year on year growth rate for this line item. Currently, I tried the formula below: Revenue / OFFSET (Revenue, -12, 0) - 1 This formula is working fine for all the months, but it is not working for Quarters or Half or Full Financial Years (FYs). The…
-
How do i start training for Anaplan Level 1 Model Building training Anaplan’s NMX
I have been stuck with Unicorn Candy Company Model building Level 1. Since, I am a student i do not have access to Workspace. How do i get workspace so at least i can start practicing model building. I am new to Anaplan any tips to master would be appreciated.
-
Retrieving a date to a module without time dimension
Hi All, I have a question regarding the last date of an item, to a module without dimension. Let me explain, i have this module : with thoses dimensions : My purpose is to get the result of the input in a module only dimensionned by "s Active" (subset of my employee list) and regarless the version, to get something like…
-
How to create a module with a Boolean option that switches off "write access" on all Boolean boxes?
I am familiar with how to create DCA to switch off the write access for a list item. This example is costs for a land appraisal. Here is a module with rows that are editable. Here is an override module where I can change access from Write: To read: Now the Pricing method for the first 3 rows are greyed out: I can create…
-
ANY formula issue
Hello, I can't seem to properly make this aggregation formula work correctly because it's based off a boolean which apparently is not filtering the list items correctly. TARGET MODULE, WKK51 Sales Returns - Actual/Forecast lists: week, scenario, customer group. timescale: NOT APPLICABLE SUM Formula: IF…
-
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…