-
Level 2 (2.3.9.2) Update Historic Volumes for Baseline Forecast
I'm having trouble creating the formula for this requirement: This is what i came up with: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 My model is taking this formula without error. This might be a silly question, but how do i check if this is correct? Here is what my module…
-
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…
-
I want to remove the time dimension in my system module. What should I do?
Hey guys, I am new to Anaplan. In the level 6 of the model builder 1 course, I accidently added time in my system module. I later realize that in level 8 that I was not supposed to do that. I know that we can change dimension in Applied To column, but what about the Time dimension? Can I remove it somehow?
-
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 not matching up with numbers from CHECK YOUR WORK
Hi, My numbers are slightly off from the Example Model. (I believe like 2 units off). Attached is my Blue Print view and Grid View. Please advice. 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
-
INV01 Line Item Formulas
Hi, Would like to know if my Line Items are correct. Please advice The Line Items are on the attached pic. Thank you
-
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
-
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?
-
Module setup
Hello Need some help in setting up a module for our requirement. We are tracking the consumption of certain hardwares at our facility. The data file looks like this, where the numbers are the consumption qty in that month.We will be getting this data every day with rolling months, meaning on Oct 1st we will get the new…
-
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:Confirmed PO Delivery Sprint 3
Hi, Would like to know if this is the correct formula for the Line Item:Confirmed PO Delivery in Module INV01. If not please give me some guidance. OFFSET('PO(Purchase Order) Submitted', Shipping Time Weeks, 0) or should I use POST(PO Submitted, Shipping Time Weeks) 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
-
New Level within Hierachy
I have an established hierarchy and need to add a new level within the middle of it. Currently, the hierarchy looks like M1>M2>M3. I will be adding a new level between M1 and M2. The current M2 and M3 will be children of the new M2. My concern is around the formulas already associated with the levels in their current…
-
Unwinding debtors into future period
Hi, I have a line item with the balance for each invoice which is a list at the end of the month I have another line item for the predicted timeperiod that cash is expected I want to forecast cash received based of only the current months closing position. regards
-
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
-
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…