-
Level 2 Sprint 3 Product Replenishment dashboard - Summary setting
Hi Team, I am facing a problem with the summary settings and their display on my DB. Problem Statement: Values not Displaying in my Month Column for line items like "Final Shipment amount" /"Shipping Cost"/"Final Shipment cost" 1) Course Example summary file - This is an example given in the course, the values need to be…
-
Optimizer Timed Out Error
Hi, I am using optizer to decide for each station(or Site) who is the best supplier & terminal for supplying product based on minimum sourcing cost. Input variables: Site Demand Volume, Each supplier and terminal sourcing cost. Output variables: Site Demand volume(will be decided by optimizer) Objective: Optimized cost (…
-
Adjusting a formula
Hi, I am currently working on creating a P/L where we multiply a item by a certain percentage. To get this percentage, I had to create a another module and use past actual data to arrive at the %. The issue is now In my module of calculating the % . FY19 is the percentage I need to bring over to my P/L but everything I…
-
Module calculation - Sum values from column
Hi All! I'm new with Anaplan model building have one specific doubt, looking to the screen below i have budget, mx and campaingn columns these are columns created through a list i called dimension, i need know sum these three columns getting the quantity (K) line item, what is the best solution for this calculation ? I…
-
Formula related issues
Hi, I have two issues as descried below. Please can you help me on it. Problem 1: I have a line item A having some data and Time scale for 4 years (in months). I want a formula on the line item B which can check if all time periods for line item A have only the value 0 and no other data. Please can you let me know if there…
-
Current User Lookup
Hi, I would like to allow users to determine a target currency to use in translating values and enable that selection to be unique to them. First thoughts are that I can create a selection module dimensioned by user containing a line item formatted as the currency type. My challenge is to then direct a formula into this…
-
Level 1 Exam
Role not pulling through correctly when importing into the SYS08 Module. I have changes the format to text and to role but it's still not working. Please someone help an amateur anaplanner out!
-
Lookup or SUM between Modules with Different Dimensions
Hi all and thanks in advance. I just want to lookup an amount from one module to another one. However, they have different dimensions, so, I created a unique code to work as link between those Modules (it is a string type). How can I perform the Lookup or Sum using this unique code? I mean, I try lots of ways, and it is…
-
Returning the Date of when a contract starts
I have contracts with revenue and expenses by dates (differing start and end dates) in a module (Start date ="1", the second period ="2", so on until it ends of reached end of time periods). I'm building a dashboard which reports the start and end date of each contract, and then allows a user to input a revised start/end…
-
Get Lastoccurrence data
Hi, Please help how can I get the last value in my module. I tried to use a rank function but can't reverse the ranking to ascending because the source value are the same amount. Thanks in advance for the help. Tom
-
Model builder level 1 exam - SKU volumes not pulling through
Hi, I am trying to complete the module builder level 1 exam but the volumes file isnt uploading correctly, the data is only pulling through in Jan-19. I have revisited the content but not getting any answers, some please help!
-
Level 2 Sprint 3 Create Combination Chart for Dashboard
Hi Team, Before you publish the SYS01 Time Settings by Month module, showing the Planning Period Filter line item, filter it to show months only and save the view as Filter for Product Replenishment Dashboard. This is the requirement of the course. I applied the filter on months only & saved it as "Product replenishment…
-
calling out previous data
Hi team, How to call out previous data from numbered list similar to previous if time bounded? Please see attached reference file. Thanks, Eia
-
Data from With time to No time Dimension
How can i pull a data from a module with time dimension to target module with no time dimension using a finditem mapping made in the source data? To illustrate, my total sales of 1,000,000 was divided into 3 months(using a time dimension) using a condition that turns the distribution this way: Jan 20 - 3,000,0000 Feb 20 -…
-
Sum Data From start year in model
Hi, is there a way i can sum our balances from the start date i set in my time setting? See attached screenshot. The balances should be for FY14 = FY13+FY14, for FY17 = FY13+FY14+FY15+FY16+FY17 Thanks in advance for the help. Tom
-
how to solve level mismatch
Hi, Table A FactoryModelModel.LineamountLine.Factory JapanA X100Japan BX200Japan CY400Japan Table B Lineammount X300 Y400 I have "amount" (by Factory,Model) in tableA. I want to aggregate "amount" by Model.Line in Table B. I use the formula like "amount" = "TableA.amount[lookup:TableA.Model.Line]" but the formula error has…
-
Level 2 Sprint 3 Create filter & Saved views
Hi Team, I created the line item in SYS00 & 01 as mentioned in the requirement below. I am confused with the requirement mentioning not showing HY value until all weeks are checked. Please help.
-
TR02
Hi All, Need your advise. I have created the TR02 module using an unorthodox process to ensure that the final sales target matches with the initial sales target(Parent level) taking into account of Overrides & Hold. BUT, details at the country's line item level is not matching with 8.4 Check Your Build. Have I missed any…
-
Copy Module Glitch - Ratios Reset
Hey community members, Our team discovered a potentially huge glitch in Anaplan this afternoon, and we are wondering if anyone else has experienced something similar. We have a module that uses Ratio as a summary method on a couple line items, and after we copied this module to build out a separate part of the model, we…
-
Calculating final sales forecast
Hi, In order to calculate the final sales forecast, I have used a very unorthodox process (attached below). Now, even though the overall amount at the Account parent level is matching, however there are some mismatch with individual account line level (mismatch between my module & what is there in the Sprint 1 screenshot)…