-
Mapping issue
HI, I have one Account flat list which has code for every accounts. there is one more flat list account items which is related to items within the accounts. So one account can be related to many account items list. there is one list which consist of items levels (1-5 numbers). so now i want to have values of account based…
-
Multiple SUM&LOOKUP splitting workaround
Hi, I am trying to split multiple SUM&LOOKUP's used in a lineitem in a module in order to optimize the model performance. But while splitting the SUM & LOOKUP into different line items in separate modules (dimensioned by lists used in SUM&LOOKUP) , the result is not coming as expected. Since the size of lists is quite…
-
Formatting Views in Dashboard
Hi, I am trying to format a view for a dashboard based on the business requirements and to make it more presentable in Anaplan. Following are my doubts, * How can we change the row height in Anaplan? * How can we color row to differentiate values belonging to a single row from other rows while scrolling horizontally? * How…
-
New UX Forms - You Cannot Create This Item
I am creating a page in the new UX to give users the ability to add new Strategic Suppliers to a Strategic Supplier List. I used the Form Editor to create a form, but I am getting an error message that says "You cannot create this item". I've searched Anapedia for all things related to forms, but haven't found anything…
-
lines disapear from a dashboard
Sometimes published grids on a dashboard do not show the entire grid. As you can see in the screenshot below, the third line "Personeelskosten" at the last item of the grid is not shown. In the dashboard settings the percentage of Height are set at 499 and a minimum of -1 px. When the percentage of Height is set at 50 the…
-
I am currently working on The essentials of Model Building for customers
I have not started my Lessons training. However, I am nearing completion of the essentials of model building in the customer module. I am in course 7.6 Drill to Transaction functionality. I have tried to drill down on Pet and Food supplies expenses but get an error message. I have posted a screen shot. I am not quite sure…
-
Formula to choose Dec value
Hi All I have one unit in my module that is missing a monthly phasing for 2 years (2022 & 2023). I have value only for December, so I want to say that if there is no input in a month, it should pick up Dec value and apply it to all months from January to November. I'd prefer to avoid saying that if it's 2022 then take Dec…
-
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 INV03 Distribution center Summary
Line item 'stock exception' formula - I have summed safety stock exception line item of a major module based on 'supplied by' line item of a system module (I have used only one sum parameter. As per the training program, we are instructed not to use any summary method. However, I am getting the results only when i use…
-
Rank function Descending not working
Hi, Please help understand why my rank function is not working when using descending as my direction. Please find attached screenshot. I am expecting to do the ranking by starting to highest rank to rank 1. Thanks in advance for helping. Tom
-
FORMULA RELATED ISSUE
hello community, i have a lineitem Has Data? which is a boolean format and in the same module i have product and store dimensions i want to write a formula in such a way that if a store has a particular product then the corresponding boolean box has to be checked please help me with a resolution sai.
-
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…
-
what is "expand storage capacity"?
In 8/22, Anaplan has maintananced. its content is below. These infrastructure updates will help expand storage capacity and enhance network infrastructure. but what is expand storage capacity? what type of storage? what kind of benegit we can get?
-
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 =…
-
Level 1 Model Building
I'm not exactly sure what I'm entering wrong that's not allowing this function. (Images Attached)
-
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…
-
Forecast an amount every 'x' periods
Hi, I need to take a committed contract amount and forecast it going forward as if the contracts will be renewed for exactly the same amount once the contract expires. Contracts can be month to month, quarterly, annual, or bi-annual. The image below shows a mock-up of committed contracts in green text and how I would need…
-
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…
-
Map list items for importing to a module
Hi, I am mapping the list when I import into a module from a saved view in another model. As shown below, the source list (left) contains an item "Distribution" that actually does not exist in the list, while "Distribution total" (that exists in the source list) cannot be mapped to any target items. I made some changes…
-
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?
-
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.…
-
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…
-
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…
-
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…
-
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
-
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
-
Cross referencing List values in module through Lookup?
Hello, I have list C_L4 costing materials containing material under multiple org- profit centers Ex: Material: 136699 Profit Center: 100050: Sales Org: 2020- C_L4 Code: 136699_100050_2020 Material: 136699 Profit Center: 200050: Sales Org: 3030- C_L4 Code: 136699_200050_3030. (Cost attributes are being calculated from…
-
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
-
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…
