- Community
- :
- About neg177
Ask the Community
-
Ask a QuestionGet answers to platform specific questions from Anaplanners everywhere.
-
Suggest an IdeaShare ideas for platform improvements, training, the Community, and more.
-
Get Training HelpComplete your training with support from the experts.
-
Contribute ContentWorkshop content, submit for approval, and contribute best practices to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About neg177
since
07-16-2020
yesterday
neg177
Contributor
Activity Feed for neg177
- Posted Need Help on Line Item Formula Total Beginning Inventory on Anaplan Platform. yesterday
- Posted line item formula Stock Expectations on Anaplan Platform. yesterday
- Posted Stock Expectation Line Item on Anaplan Platform. yesterday
- Posted Line Item Safety Stock Flag Count on Anaplan Platform. yesterday
- Posted Re: 3.3.11 Activity Question on Anaplan Platform. yesterday
- Posted 3.3.11 Activity Question on Anaplan Platform. Monday
- Posted 3.2.11.1 Create Planning Period Filters on Anaplan Platform. Friday
- Posted Re: Line Item Override Amount-write? on Anaplan Platform. Friday
- Posted Line Item Override Amount-write? on Anaplan Platform. Friday
- Posted INV01 Line Item;Shipping Cost on Anaplan Platform. Friday
- Posted Line Item Shipping Cost INV01 on Anaplan Platform. Friday
- Posted Line Item Final Shipping Amount INV01 on Anaplan Platform. Friday
- Posted Re: 3.3.7.2 Add DCA to INV01 Inventory Ordering on Anaplan Platform. Friday
- Posted 3.3.7.2 Add DCA to INV01 Inventory Ordering on Anaplan Platform. Friday
- Posted INV01 Reorder Flag Line Item on Anaplan Platform. Thursday
- Posted INV01 not matching up with numbers from CHECK YOUR WORK on Anaplan Platform. Thursday
- Posted Re: INV01 Line Item Formulas and Results on Anaplan Platform. Thursday
- Posted Re: INV01 Line Item Formulas on Anaplan Platform. Thursday
- Posted Re: Line Item: Safety Stock Exception Count on Anaplan Platform. Thursday
- Posted INV01 Line Item Formulas and Results on Anaplan Platform. Thursday
39
Posts
1
Kudos
8
Solutions
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
yesterday
|
yesterday
Hi, Need help with Formula. I have the following below. Please advice. 'INV01 Inventory Ordering'.Beginning Inventory[LOOKUP:'SYS07 Distribution Center Details'.Region] Thank you
... View more
Labels:
yesterday
Hi, need guidance with the following formula. 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS04 Product Details'.Product Family, SUM:'SYS07 Distribution Center Details'.Country] Thank you
... View more
Labels:
yesterday
Hi, Confused with this formula. I have the following below. Please advice. 'SYS07 Distribution Center Details'.Country[SUM:'SYS04 Product Details'.Product Family] Thank you
... View more
Labels:
yesterday
Hi, I'm having trouble writing the formula for this line item. This is what I have so far. Please advice. 'INV01 Inventory Ordering'.Safety Stock Exception Count[LOOKUP:'SYS08 SKU Details'.Country Made] Thank you
... View more
Labels:
Monday
Hi, Not sure which line item I need to write the formula for. Also this is the formula I came up with. Please advice. MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter) Thank you
... View more
Labels:
Friday
Confused on which Line Item I'm building a formula for, I'm assuming both. Also this is the formula I used to so that the weeks in that month are selected as well when you select the month are as follows. Please advise. MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter), Kind of confused why would not want to use WEEKVALUE if I want to show my Weeks. Thank you
... View more
Labels:
Friday
I used this because I thought it meant the Suggested Order Amount, but it means to use Override Amount Line Item? IF 'INV01 Inventory Ordering'.Submit Purchase Order Request AND 'INV01 Inventory Ordering'.Override Suggested Order Amount THEN TRUE ELSE FALSE
... View more
Friday
Hi, Stuck with this formula for the above Line Item. The formats are Boolean and Number so not allowing me to use a similar formula like I did for Override Shipping-write? Please advice. IF 'INV01 Inventory Ordering'.Submit Purchase Order Request AND +'INV01 Inventory Ordering'.Override Amount THEN TRUE ELSE FALSE Thank you
... View more
Labels:
Friday
Hi, I'm confused on the Line Item Formula above. Please advice. 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:(Final Shipping Cost/1000)*'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'] Thank you
... View more
Labels:
Friday
Hi, I need guidance on writing the Formula for this Line Item. My formula is below. 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:Shipping Method} Thank You
... View more
Labels:
Friday
Hi, I need help on this line item formula. Below is the formula I came up with. Please advice. IF NOT+Submit Purchase Order Request THEN 0 ELSE Suggested Order Amount for the Month NOT(Override Suggested Order Amount) THEN 0 ELSE Override Amount Thank you
... View more
Labels:
Friday
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 formulas. Please advise. Thank you
... View more
Labels:
Thursday
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
... View more
Labels:
Thursday
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
... View more
Labels:
Thursday
I got the formula. I used HALFYEARVALUE to get my values for the Line Item Safety Stock Target. Thank you
... View more
Thursday
I'm having a hard time trying to figure out what formula I would use for Saftey Stock Target Line Item. This is the formula I'm using WEEKVALUE('DAT04 Distribution Center Parameters'.Weekly Safety Stock), not sure what formula other than weekvalue. thank you
... View more
Thursday
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
... View more
Labels:
Thursday
Hi, Would like to know if my Line Items are correct. Please advice The Line Items are on the attached pic. Thank you
... View more
Labels:
Thursday
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
... View more
Labels:
Thursday
And also that means this one for the Shipping Methods Line Item 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Supplied By] is correct because my Source has only one dimension 's G3 Location Distribution Center' and my target shares the same dimension. #thisformulaisgoochie?
... View more
Thursday
You are in much less doubt the bestest person on earth! Is the below Formula correct? 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Thank you
... View more
Thursday
So OFFSET can only do so with a singular value verses POST that can pull in multiple values....correct?
... View more
Wednesday
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
... View more
Labels:
Wednesday
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
... View more
Labels:
Wednesday
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
... View more
Labels:
My Accepted Solutions
| Subject | Views | Posted |
|---|---|---|
| 10 | yesterday | |
| 19 | Friday | |
| 29 | Thursday | |
| 32 | Thursday | |
| 30 | Thursday |
Posts I kudoed
| Subject | Kudos | Author | Latest Post |
|---|---|---|---|
| 1 |