-
Acceptable uses of SELECT
Hi All, It is generally accepted that we should not use SELECT if LOOKUP can achieve the same outcome. Therefore, when is it acceptable to use SELECT? I have been working on generating a variance report where we can retain the original line item formats. Therefore, I can not use a simple LISS to generate the report where…
-
Looking for Best Practice in combining text parameters and monthly amounts
Hello! There's a situation where I've seen in many models and already there in the two companies I've worked with Anaplan. I've also seen several solutions, none of them being great. I'm looking to the community to see if anyone has a better idea or if there's already a Best Practice available for this. I tried looking for…
-
Actual Years Boolean in Time Filter Module
I'm sure I'm just overlooking something simple, but I'm hoping to get a quick answer out of the community. I have a global Time Settings module with the current period in it (Current Month line item and Current Year line item). In a Time Filters module, I have a boolean for Actual Months (all months preceding Current…
-
Data import
Hi, I was trying to import the volume file to REV02 Volume Input (Level 1 lesson 8.5.3), but I received an error message about the column header in the file do not match the import definition as below: I had selected (see below) or attached image I believed the column header was wrong. Will appreciate someone could assist…
-
Connecting Models - Data Not Flowing in Correctly
Hi AP Community, I have 2 models, one was a prior forecast and the other is the current. I have identical modules and I'm trying to import the data from the prior forecast model into the current forecast model so I can do variance analysis. I am able to import the prior forecast model data successfully, however when I see…
-
Designating Sales Reps to Accounts Process
How the scenario for New Territories and New Sales representatives are handled? when there is no previous year data , when the New territories is planned not starting from First month. What if new sales representatives are planned?
-
Fetching data from one module to other module
Hi Team I have one module called SAP inventory detail which consists of one numbered list, and other module called Aggregate Demand schedule which consists of another numbered list. I need to fetch the line item called demand from Aggregate Demand Schedule to SAP inventory Detail module. Can anyone please help me on this.…
-
Allocate data of 1:N within same list.
Hi, I have a list with items A,B,C the data of A should be mapped to B and the data of C should be mapped to B. and it is 1:N mapping A1->B1 A1->B2 A2->B1 A2->B2 C1->B1 C1->B2 C2->B1 C2->B2 I have done the above mapping by creating a concatenated list but I am not able to fetch the data by using this mapping to target…
-
How do I find a line item in a list subset?
Hi, I have a module in which I'm trying to determine if accounts are within an account list subset, if so return TRUE, so that I can then filter those records to import to another module. I cant get the finditem to work for me, is there another way to do it? I also tried using a line item subset, but failed... the…
-
Formula
@jasonblinn Thanks for your previous answer. I had one more question. Here I am use 2 modules, puling data from one modules to another with same line items by directly referring each line item. But I am not getting the values into target modules. From 1st snapshot I am trying to pull data into 2nd ss. Can you please help…
-
Need help formatting and writing this formula.
Hi, The Excel Version of the Formula I'm trying to write is =MIN(ROUND(ABS(((UI20+UJ9)-UJ40)/Collection_Funding!UI3),2),0.98) The Formula I'm trying to use is MIN(ROUND(ABS(((previouse(total eligible principle)+paydown)-Min Assesset Requirment)/Previouse(Collection Funding!RTR)), 2), 0.98), which I do not believe is 100%…
-
Formula or Filter
Hello Everyone, I need here in getting solution for this issue, my question is. "change rule: when Forecast AND Actual equals 0, the deviation % should be 0% and not 100% as now" so where do we change the rule and how do we do it. welcome to hear solutions, Thank you.
-
Average of Every Monday
Hi Team, I have to find Average of particular Column based on the DATE . (i.e.) * To find How many Subjects have been Enrolled in a Particular Site? * To find Average of subjects enrolled per week, we are calculating Every Monday(We used WEEKDAY function to get a first day of the week.) Can any one help me with this?…
-
Pull data into current year from previous year where both are list items
How do I pull data into current year from previous year where both are list items and both are used in a module?
-
How to get the nth occurrence of an item using the same list
Dear Community, Hope you can help me with this requirement, this is the scenario: there is a list of products and a dedicated module that allows the user to select the replacement product from the same list. A product can be replaced by one product only, while any product can replace multiple existing products. Referring…
-
FIRSTOCCURANCE should happen based on High number
Hi All, Is it possible to get FIRSTOCCURANCE based on Highest Number? As per the below Example: 1. "PRODUCT A" has the Highest Transaction number- 4,000 in the second Hierarchy(Bucket 2). "PRODUCT A" Will TRUE Under BUCKET 2 Parent. 2. "PRODUCT C" has the Highest Transaction number- 3,000 in the first Hierarchy(Bucket 1).…
-
[Guide] Multi Level filter selection on composite hierarchy
If you are using a multi level composite hierarchy as your main reporting list (as you should vs ragged), you have encountered the need to filter it and display many levels of it in many different dashboards. Recently re-discovered a solution that I find quite handy and decided to share it here. Here's the result. As you…
-
Stagging List
Hi Team, Please help me with the below requirement, I am using two list items 1. Product List (Stagging List with Hierarchy) Ex: 2) Key Products(Flat List) Ex: Having only one Product: PRODUCT A In the Product Hierarchy list, I am maintaining one attribute called Key Product ? with the boolean format. Now, in Product…
-
Help needed for Lookup formula
Hi I need help with solving for a lookup formula am trying to build in Level 2 Supply Chain Model. Have been trying unsuccessfully to get it to work so need some advice on the solution. Here's the situation: 1. Lookup formula needed for Growth Rate % at SKU Level in DEM03 Demand Forecast module (time in weeks); 2. Growth…
-
Accessing Non parent list items from parent list in a module dimensioned with child list.
I have List items of list X- A,B,C,D,E,F List items of list Y- A1,A2, B1,D1 ,D2, E1 (Child list of list X) here item C,F don't have any child . I'm using List Y in a Test module line item1 - displays all list item at child level (i.e list item of List Y ) line item 2- I want to display all list item from list X issue-> i'm…
-
Level 3 Process Flow and UX Design: Redistribution of Sales Target
Suppose if the Regional Sales Executive override the sales target for one account and hold the target for another account, in that case, balance sales target will be re-distributed basis what logic? Does the platform need to re-calculate the redistribution % and then distribute the balance target?
-
LVL2 sprint 3 inv01 correct formulae but wrong figures
Hi all, I spent a lot of time checking all the formulae and they seem correct, but still I got the wrong figures at last. For example, the instruction says "The Confirmed Purchase Order Receipt value has updated to 8,194 is also in Week 3 FY20 column" whereas my result is 8,020. I also found that only the Beginning…
-
TIMESUM cant aggregate(e.g. MAX) time period on time period dimension?
Dear All, According to Anapedia, "Line item to aggregate The value to aggregate over time. The Line item to aggregate argument can be a line item of any format." But, when I try to aggregate time period line item as follows, it returns an error. Example Timesum Date = TIMESUM(Date, TIME.'Mar 18', TIME.'Jun 18', MAX)…
-
Boolean Filter for Salary Rank function
Hi, I want to only show the top 10 earners in each department (List hierachy E1 Department is top and E2 Employee below). I have created a RANK that will give organize numbers lowest to highest based on each department, But the numbers do not "start over" for each department. So there is only one department, that has RANK…
-
Filter Full Year
i want to ask, i have module like this the module have 2 lines item actual and budget for the display i used filter for this, but the problems is in the full year the line item is actual, i want to change to bottom up amount, so if on the FY 21 have actual and bottom up amount FY is Bottom up amount and if FY 21 is actual…
-
How to show summary levels dynamically for automatic update of chart
Hi, I have a module with time and client list as dimensions. The client list looks something like this: Economy Clients - Economy Client 1 - Economy Client 2 Premium Clients - Premium Client 1 - Premium Client 2 The line item, for example, is Revenue. I published the line item as a chart by manually selecting only the…
-
Chart in Anaplan Dashboard
Hi team, There is one Numbered List(Site List) and a Line Item(WFC). And we need a Chart(Dot Chart) with WFC >6 and WFC <6 in different colors. Can you please help me on this. Thanks
-
REV03 Margin Calculation
Hello, How can I please, desincrement my (Renenues-Cost of sales and margin ) I just wanted to test this , unfurnately, everything is changed. Hello, how can I desincrement this?
-
Failed Order List Action
I have a Order List action that works great in Dev, but fails in test. No error message - Just Failed Action Message. Detail reveals: The model and Workspace ID are the same as the Model where the action resides
-
MAKELINK Embedding Issue
Hello, I am trying to embed a MAKELINK formula within a list, however the list item I want to embed the MAKELINK into is a function of a LOOKUP, and therefore I am struggling with how to format the MAKELINK. See below: The current List Item title is "Item Name." The current formula for "Item Name" within the list…