-
How to add newline in Email body text field of MAILTO function
Hi , I am trying to add newline break to make the email body readable while concatenating line items . Would appreciate if this is feasible in Anaplan. Thanks, Deepa
-
Line Item: Safety Stock Exception Count
Hi, Would like to know if the following formula is correct for this Line Item: Safety Stock Exception Count. If not please advice. I also set the Summary Method settings to SUM seeing its asking for total numbers of happenings (is this correct)? IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0 Thank you
-
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…
-
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.
-
Level 2 Sprint 1, Create a filter to show only half-years. (Hint: Use a system module)
Can anyone offer guidance as to how to create the filter to show only the half year view? (for 1.6.3.3 Create Saved View for Export.) I have this now: So in order to hide the FY20 and FY21 columns to meet the requirement, the hint is to filter using a system module. So i tried this: But this resulted in hiding all the…
-
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…
-
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
-
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…
-
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…
-
How to build Parent/Child hierarchy for different sets of children
Hi Need your help in developing a solution for this requirement. Please see the attached data sheet.We execute Jobs to make Assembly Items by consuming Comp Item numbers (Typically we consume 2 types of Comp item numbers to make one Assembly item). One Assembly item can be made in more than one way.(i.e. We can create two…
-
L2 Supply Chain Model DEM01 & DEM02
Looking for an opinion Is it best practice(DISCO) to have the following in a single module or is it preferred to have it in separate modules DEM01 & DEM02: Line 1 : Growth % by Month ( time set to month) Line 2: Growth % by Week ( time set to week) Thanks
