
Modeling
Modeling
Discussion List
- 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} …
- 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 Mad…
- Hi Im revisiting my formulas and find that the output is the same with either A or B : Is there a difference between the two ? I want to apply the monthly growth values to weeks. A. MONTHVALUE('Volume…
- Activity asks to create a view for export for module DAT04 Distribution Center Parameters.I cant understand the Hint.Why to use system module we can use filter in module and show only half years? Why …
- 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
- Activity 1.5.8 asked to save a new view Export but in my final view (file attached"export view")All weeks sales are adding up and showing under Jan19 while it should be blank as shown below What am i …
- Curious to learn more about the calculation engine and how formula impact your model’s performance? In this session, discover techniques for improving calculation performance through formula optimizat…
- Hellow Experts! We need to store RUN LOGS and ERROR LOGS for automated actions (ex: IMPORT) using Anaplan Connect. We have scheduled .BAT fils to automate actions everyday (Ex: Load GL data from SAP e…
- Hi Everyone I am using '52' to show previous year data of same month by subtracting: 'PY Month(week)' - 52 Is there a function or alternate way to use replace '52' and not use it in formula as a numbe…
- 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 Shi…
- 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 Inv…
- 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 he…
- 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(En…
- 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 …
- 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
- 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 t…
- 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'.'Shippin…
- 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…
- 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 d…
- 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 t…
- 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
- 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 u…