-
Line Item: Shipping Time Weeks
Hi, Would like to know if this formula is correct. I'm thinking I would need another mapping, but have no line items that would match the format of my source. 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product] Thank you
-
How do I get my list with the same names but different parents to work?
I have a list that has Meetings, Food, and Cars. These 3 items should both be under domestic and international as parents. When I try to enter them in manually they just move parents and when I import they it gives me a warning. I tried to create codes for them individually as well. Would I need to use a numbered list?
-
Pareto Analysis
Hi, Currently I am doing Pareto Analysis to identify top 80% of the Sku (S3) at Department level (B5) and at SKU Group (S1). The result expectation is like last 3 columns (F to H) Note: The Sum(1791) is the total of Sku at group for the year. Please assist your ideas to achieve this in Anaplan.
-
Line Item: Suggested Order Amount for the Month
Hi, Just want to make sure my Formula for this line item is correct. This line item formula references the monthly value of the Forecast Demand. If the Forecast Demand for January 2020 was 1,030; this formula would show that value for all weeks in January. MONTHVALUE(Forecast Demand) Thank you
-
INV01 Line Item: Forecast Demand
HI, Getting stuck on this formula and I know it is so simple. I know I need to pull in values from my DEM03 module Line Item Demand Forecast into my Line Item Demand Forecast in INV01 Module. I just dont know if I should use a LOOKUP to bring that data in. Please advice. My Formula DEM03 Demand Forecast'.Final…
-
Exporting an Anaplan Model
Hi there, I would like to download or export an entire model so that I have a backup stored locally and to reduce storage space. How is this managed through Anaplan? I can see there are some options through Model Management however I don't see any option to Export? Thanks, Liam
-
Convert Text to Number following comma format
Hello, Is there an easy way i can convert number to text format but still following the number format for comma? Thanks in advance for helping. Tom
-
Offset Function to get monthly value
Hi, Please help how I can get the monthly value from our DATA Collect to a line item in Year format. In my example screenshot below, I need to pull the Jan 2020 data to the Jan line item. I tried to use offset to get the Jan value but with no luck. Thanks in advance for helping, Tom
-
INV04 Distribution Center Capacity
Hi My Capacity % numbers look weird, Am I missing something when calculating the beginning inventory. Pls refer to img. Appreciate your help. Thanks
-
ROUND Function Not Always Rounding
Hello, I have an issue with the round function. We are rounding after a complex function and then taking the text value and using that to look in a list. In a few cases only, nothing is being retrieved from the list because the text value has more characters than it should. For one example, reducing the issue to the…
-
Level 2 Sprint 1 User Story 4 - Time (half year)
I'm on Level 2, Sprint 1, User Story 4 and I'm stuck on creating the DAT04 Distribution Center Parameters Module. What's confusing me is the Time (half-year) dimension. Am I supposed to leave the regular time dimension in there when i create the module? Here's what i used, to no avail: I see that the data file for Weekly…
-
SYSY03 Account>Product Details (L3)
In my SYS03 Account>Product Details module, I can't seem to populate my P2 Product. Everything I have tried returns a blank - doesn't show any data. I wonder what I'm doing wrong. I've tried to getting the ITEM('P2 Product) = shows nothing.
-
New UX: Ability to enter carriage returns on text fields
This seems pretty basic to request, but I'd like to be able to drop down a line or two in a text field, without having to use another text field (classic does this). For example, in our classic model, all of our pages have a Single text field below the page's title that include something like this... PURPOSE: (description…
-
Identify Incorrect Amount
I am trying to identify if the amount entered is in correct format and also if it is Blank or not. In order to achieve that I am importing the amount in both text and numbered line item. - Below are the different results we get when we import the amount in different formats in text and numbered line…
-
Input data in a module published in a dashboard
I created a module with subset list as row and column line item named as assumption methods. Row Subset list are expense accounts while column line item are assumption methods e.g average YTD actual periods data , escalate YTD actual periods data or Input fixed amount I would like my module when published to dashboard to…
-
Information flow between Docusign to Anaplan
Hi, I see that within the Docusign integration that information can flow from Anaplan to Docusign but is there a way to send entered information (inputs) back to Anaplan as well? Information such as Name, email, and signature status is capturable but I am unsure about other numerical data that is input. Help will be…
-
Sorting date and override
Hi there, I need to sort by both the plan effective date (in reverse chronological order) and if an override was filled out. However when I click on the sorting I can only sort on the date line item or the override line item. When I sort on the date line item it ignores the overrides that do not have a date and when I sort…
-
Not able to apply SUM or LOOKUP
Hi, I am trying to get the Proceeds amount for each Deal in Deals list, however not sure how can i get it, Kindly advise. Here is the scenario: Target Module List : Deals, LINE item = LTD proceeds Source Module : List = Deals and Trans Type (Proceeds as one of the TT), Line Item = Amount Thank you!
-
summary method
Hi, question please. How can I sum up #transactions #1-#5 without adding the top list (alo world)? The total should only be 249 but the values is 5,772. I already edit the summary method to formula. Thank you.
-
Level1 exam
I have no list with name All Roles but still getting error while putting it as top level in EMP 03 Role
-
LEVEL 1 MODEL EXAM
Cleared the exam but was not able to get one answer in Activity related to calculating expenses by region and role Can anyone let me know what was the correct answer or whom to contact for the same
-
Model Builder 2/- TRA01 Shipping Time in Weeks
Hi Been trying to figure out this formula but unable to due to the Year to week Lookup criteria . Any suggestions pls The formula for 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' is invalid: 'Shipping Time (Weeks)' = YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)' [LOOKUP: 'SYS01 Time Settings By…
-
Model1 Chapter 13 Price and Growth assumption Page
Please help 2 things different in my board and how to fix it 1.Margin Summary chart and Forecast periods grid have "US" and "Chocolates" in left hand corner but not in my board why? 2.My board have 2 times US mentioned in top right corner
-
Days in Month
Hello Everyone, New model builder here. I'm trying to figure out how to display the amount of calendar days in month. I used DAYS() but it's coming back as 28 days 28 days 35 days which I presume is because we are in the 4-4-5 timescale. Is there a formula that I can use to figure out the days for a current period? In…
-
Circular Reference for rollforward calc
I have a circular reference issue that I have not previously seen. The screenshot below shows a relatively simple example of a roll forward calculation where balances are carried forward. The issue I am having is that I would like the 'Out' line item to be dependent on the 'In' line item and simply take data from the 'In'…
-
Comparing List Items
Hello All, I'm attempting to do expiration calculation on lot codes based on a few points QTY in the lot Sell by Date Days on Hand When importing the inventory, we add 1,2,3 etc... to each line and use that as the code for the list. So we import the codes into the list first, then in the module it would look something like…
-
Data import of different Dimension
I apologise for asking a basic question. As I have none to assist, so seeking assistance from Anaplan Community. The Source Data Module has Yearly Values. The Target Data Module will copy all the values in Weekly as well as Monthly. Please assist me, if any Document is there in Anapedia, mentioning the way out.…
-
Formula for Number or text
Hi, Is it possible to format a line item so users either input a number % or "n/a"? Thanks
-
Pivot conditional formatting multiple levels - format selected columns
Hi Can anyone advise if it is possible to give conditional formatting only to the 1 of my column levels if there are multiple levels? I have the following columns: Level 1: account (sales and ebit) Level 2: scenario (act, bud, forecast, and variance to bud and forects It seems i can only filter based on account, so it…
-
Filtering a module to only show non-zero entries
Hello I have a module where the rows are line items and the columns are list members. The view I am trying to create of this module is intended to be used so that we can easily identify any data that has been loaded to a combination of product, company, and GAAP/STAT incorrectly. I want to filter this view so that it will…