-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi, I need further clarification. Do I create the new Line Items that are listed here and then create formulas for each based on the specific purpose? I just need clarification on what I need to do here. I have attached a screen shot of what I did so far by adding the Line Items, but have not formatted yet nor written…
-
Text to Date conversion
Hi All, My import has dates in following format: "01-sep-20" and I want to convert it to monthly date "Sep 20". I was trying combinations of PERIOD, DATE, VALUE: PERIOD(DATE(VALUE(LEFT('DATE (txt)', 2), MID('DATE (txt)', 4, 3), VALUE(RIGHT('DATE (txt)', 2)) But it seems that it won't work because it doesn't recognize…
-
INV01 Reorder Flag Line Item
Hi, My Reorder Flag Line Item is not working properly. This is the formula I have, and attached you can see that Week 5 nor Week 6 are not checked when they are supposed to be. Please advice OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0 Thank you
-
INV01 Line Item Formulas and Results
Hi, Attached are the Formulas and Results for INV01. My weekly numbers are off by 2 units and my monthly numbers are off as well by the total number of units by weekly numbers are off. I have checked all my inputs and cant seem to find the problem. Attached are my pics of INV01, Please advice. Thank you
-
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
-
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…
-
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…
-
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.
-
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…
-
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…
-
IS Summary
Hi All, I just wanted to understand the importance of Is summary in Anaplan. I have a module created with Is Summary switched on for a line item in my module which is preventing that line item from coming in the export view taken out by omitting summary items. When I remove the checkbox from is summary for that line item I…
-
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…
-
Anaplan usefulness over others
Hi Friends, We can perform What if analysis in Tableau. So can't we directly import data from SAP and perform better data visualization there? Tableau also can do Budgeting & Forecasting. Why do we need Anaplan in between?
-
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
-
Ranking across a dimension consisting of multiple list items
Hello, I'm trying to create a sort of 'heat map' based on percentages within columns in a table. Basically, what I'm trying to do is transform this table into something where each column would be separate from the other in terms of conditional formatting. For example, 'training period' would have 'problems with…
-
Formula - Yes, no, n/a
Hi, How do I build a formula which states if a = b, then "not required", if a > b, then "yes", and if a < b, then "no". Thanks in advance
-
PREVIOUSITEM() - PREVIOUS() on a list
Referring to the previous item in a list is a nightmare: You can write a lookup to find the previous item, but as soon as you try to use it you get a circular reference. Sometimes you can get round this with creative use of the CUMULATE() function on your list, but sometimes you can't and you need to map your calculation…
-
Level 2 Model Building/ 2.4.7 Activity
Hi, Having a hard time figuring out how to write a formula for Line Item forecast cf in Module DEM03 Demand Forecast. The instructions are below. Write a formula for the line item: * If Initial Demand Forecast is EQUAL to the Final Forecast, set value of Forecast cf to 0. * If Initial Demand Forecast is NOT EQUAL to the…
-
FX Conversion Help
Hi, I currently have a list of bank accounts in various currencies. I need to convert these currencies into the product currency. I am currently converting all bank balances into GBP using a FX module and then converting all back to the product currency. However, is there another way to do this? The excel file I'm trying…