-
LVL2 CONCLUSION Export of Beginning Inventory
I have a question regarding Export of "Beginning Inventory". It all look ok and I can do the export to csv-file with correct columns, rows and data. However, since as I understand it the export shall include P3 SKU code, and instructions tells me that we dont need to create a "Code" line-item, so if that is the case how…
-
Workflow and Dynamic Cell Access
Hi, I would like to set up process control for forecast planning. For example, after operating unit users submit operating units' report, they can not edit any more. Then division users review and edit the operating units' report and then submit total divisions' report. And division users and group users can see the…
-
Active Version
Hello Community!! I have created a Custom Version list (v1, v2 and v3). I have a module with Accounts list and Versions list applied and a Active boolean line item which have few Accounts as true in V1 and few other Accounts as true in V2 and like vise for v3. We have another line item which is All Active which should show…
-
Production List Node selection
Hi All, I have 2 Module, One used Level 1 hierarchy(as dimension) and 2nd one uses (L2 hierarchy as dimension). In second Module Line item, I want to pick value from Module 1 line item but from a specific member. As my Lists are Production enabled , I can't use select function or Item() in this case. Is there a way to…
-
level2 sprint2-DEM03 Default Version Formula
Hi Friends iam doing level2 sprint2 model iam facing difficulty in writing a formula for Default version....can any one guide me
-
Level 2 Sprint 3: INV01 Module Line Item Formula Details
Dear all, on this section is required for those line items: Confirmed PO Delivery line item Confirmed Purchase Order Receipt line item to use the formula OFFSET, but I am not able to manage the proper result using that formula but I was using the formula POST and please refer to the print screen The tips on the training is…
-
Dependent dropdown using flat list
Hi, Is it possible to do dependent dropdown using 2 flat list. Eg. I have one flat list for levels (l1 to l5) and one flat list of exhaustive list items of l1 to l5. Now I want to do dependent drop down based on the first flat list which is levels list that if I select L1 then I am able to see L1 items in the drop down.…
-
Unexpected consequence of BLANK = BLANK and list item deletion
I wanted to share something that could easily catch out the unwary and have unexpected consequences. Let's say you have two line-items (say listFormattedLineItem1 & listFormattedLineItem2) formatted on the same list (formatList) and you compare them in a formula as part of an IF THEN ELSE - e.g. IF listFormattedLineItem1 =…
-
How to create an alternate/Parallel hierarchy
Hi Team, I am new in the Anaplan. Could you please explain me how to create an alternate hierarchy with example? Thanks!
-
Line Item Filter based on Page slector
Hi All, Can I filter my line items on a module based on my dimension page selector. Say on Total Org Level I want to view different line item and when below levels are selected I want to see different line items. Thanks Madhu
-
Assigning Rank
Hi, How can we assign rank to the method that includes two lists. For example i am trying to assign a rank to particular forecast method(list) based on MAPE and my module is dimension-ed by product and hospital list,but rank function is accepting only one list in the formula. Is there any other function to do this? Please…
-
Copy Down/Across
Currently I have transactions which run in Lakhs. I am trying to bring in a comment again every transaction by copying down but Anaplan has a limitation saying that only 10000 rows can be copied at a single time. Even I tried the conventional method Ctrl+C and Ctrl+V but still its the same issue. Is there any workaround…
-
Products with different Unit of Measure
Hi How to create products with different unit of measure(UOM) and any feasibility to take UOM Conversion, is there any workaround for UOM conversion. Thanks Sri Nitya
-
Catering for Jagged Hierarchies
Just ramping up on lists and from my previous experience many clients have jagged hierarchies (i.e. there is not a consistent level of parent-child relationships). Just looking at composite lists these require the hierarchy to have a consistent level. How would jagged hierarchies be catered for?
-
How to show line item data with time in columns parallel?
Hi, Just wanted to check, can we show line item data with time in Columns in parallel?(apart from using total all periods) Attached screen for detailed understanding Thanks, Dileepkumar B
-
List Item Limit Reached
Hi everyone. Sorry to drag this topic back up to the top but I encountered a rather strange issue today. My standard list hit 1B list item record limit even though there's only 12 million list items. So I checked all my standard lists and saw that the record limit is growing on all of them after each import. Did I…
-
Tooltip for Cells
Hi Team, Is there anyway to create Tooltips for individual cells? I know you can create them for a module but I require more detail @Hayk I saw that you requested this in the Idea Exchange & also you mentioned a workaround involving involving a formula which displays in the drill down window....any chance you could explain…
-
Minimum value through out a 12w period of time
Hi! Hope that you all are doing fine with this crisis! I have a line item that, for each reference, calculates the balance between need and stock for each week. I would like to create another line item, without the time dimension, that gives me the worst situation in the next 12 wks for each reference and (another line…
-
User Access Issue - Cannot insert without a parent
Hi, There are two lists: A (parent) and B (child). List A has selective access turned on. Now, one of the users is not able to load items into the list B without a parent even with the proper access to the parent list. They are able to load only with Workspace Admin access. Attached is the error that the user received.…
-
Issue in fetching data from one module to another
Hey Everyone, I am facing a problem while taking datas from one module to another module. I have to Fetch data from detailed level to aggregated level. My Source File is containing more detailed data and my Target module is supposed to have the aggregated data from source. As my target and source file is containing almost…