-
Changing the display view of Parent/child structure
Hi Please find the attached screenshot showing the display view of Parent/child structure in a Module. (PC3-12800 is the parent of 4GB/8GB/16GB/32GB PC3-12800). I want to display the parent at the top of the children instead of below the children. Anybody can suggest how to achieve this? Thanks Regards Prabakaran
-
Use Left Equation on Lineitem with Quarter Format
Hi, I am trying to take the first 2 characters from the "Quarter Code" lineitem so that I can identify the correct quarter for my week Time dimension. I tried using Left equation but it's not allowing me (tried using TEXT() on the quarter code but returned an error). Does anyone know a way that I can retrieve the first 2…
-
Workspace Admin hampering Report Access
Hi, I have a Dashboard which has a grid with some data on it. I see all the rows (the dimension is in the rows and LI in columns) when I have the Workspace Administrator access but I see nothing in the rows when I remove the Workspace Administrator access. With Workspace Admin access: Without Workspace admin access: Can…
-
ANY for List WIthout Top Level
Hi Team, I have a list without a top level (Ramp-Up %'s which do not require to be aggregated) but I need to be able to determine if any of the intersections have a value for a Filter Boolean Is there a formula/method to return a Boolean if ANY item for a list has value in a module. This is calculated from a module without…
-
MONTH Formula providing unexpected results with Fiscal Year beginning in February.
In the screenshots provided above you will notice the Month Value line item have a different value for the months in FY19 than in FY18 ***Formula is MONTH(ITEM(Time)). In FY19 you will also see the value of 9 be returned for September and October and 12 returned for December and January. Can someone help me better…
-
Creating Hierarchical in Datahub
Hi All, Recently i've started Level 2 Model Building and one of the topics in Datahub says -> it's best to create Hierarchical lists in Spoke model by taking data from views created by Flat lists in Data hub but what i feel is it's better to create Hierarchical list directly instead of creating Flat lists and then…
-
How to enter multi lines text and display in UI
May i know how to enter multi lines text and display in UI? I tried with line item with text format, able to input line break by ctrl+alt+enter in edit mode. But in UI, still shows as 1 line. Is it possible to show as multilines as well?
-
Formula assistance! SUM?
Hi, Still relatively new to Anaplan, but need formula assistance. I have created an input module for users to input data for a region with list attributes of internal/external and discretionary/non discretionary. Then created a GBP conversion module: I'm now on an output module, but I can't seem to sum on the…
-
Need to display missing price ranges along with valid price ranges
Hi Folks, Wish to hear you are safe & healthy!!! Got a specification to display the missing price ranges along with valid price ranges in a module where we calculate the price of the contracts based on contract quantity for each supplier & materials. In this module, we calculate the contract quantity and appropriate price…
-
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…
-
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…
-
Look up to Child
Hi, This is a bit Urgent. If someone can help me soon it would be great. Thank you. I have a Flat List as below with Property A. In a module I have checkbox 1 which is User input. Checkbox 2 should be checked if Checkbox is TRUE for parent item as below. If list item with property 'Parent' is checked , all the child items…
-
Inputting product mix % via a dashboard
I have a mix of products which must always total 100%. When forecasting, I would like the ability for the user to either a) type in the product % mix, or b) increase one whilst simultaneously decreasing another (of their choosing) via a dashboard. If possible, could anyone help with how to set up point b?
-
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
-
Count Function
Hi, I have a line item 'country' based on which my account module is developed. These accounts are mapped to countries. I need to find out the count of accounts from each country. In the sample below, there are 5 US accounts, 2 Canada and so on. How to come up with the count of UNIQUE accounts based on each country? for…
-
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…
-
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 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!
-
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…
-
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…
-
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
-
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!
-
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
-
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.
-
LEVEL 2 SPRINT 3 INV01 Module PO line item
Hi Team, @einas.ibrahim I am stuck in below Formulas attached in PO1: My formulas are attached in PO2 Problem Statement: I used POST function for "Confirm PO Delivery" & " Confirm PO Receipt" but when i ticked my checkbox for week1 its not posting inventory values automatically to WEEK 3. when tick my week 3 checkbox also…
-
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…
-
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)…
-
Color Map
Can we build something like this in Anaplan with the five colors? I can get the data together but can't think of a way to get five colors? Thanks, Debbie
-
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…