-
DigitalCPX 2020: Expert Advice: Model Cleanliness with Rob Marshall
It’s not too late for Spring cleaning! In this session, review and follow guidelines to effectively clean-up your model and optimize it as you build. https://www.youtube.com/watch?v=Vdrzgsbd3no We will focus on three key concepts: * Performance * Scalability * Maintenance Don't miss the Best Practice article and Guide to…
-
how to get a value of last week in a quarter
please help. we have scenario to get the value of a numbered field of last week in a quarter. For example we are in Q 1, we want the value of week 13 (which is last week in first quarter). do we have any functions available to get the value?
-
L1MB - rep02
I'm having trouble with level 8 Rep02 I'm getting the following error: Data type mismatch: format other than LIST or DATE being referenced as a relation I hope you can see my screen print with the other modules referenced
-
Auto Order Lists and API Enhancements - Help!
Anyone know where I can get the instructions on 9/26 release notes to automatically reorder lists and what the API enhancements are? Looks like some game changer upgrades! https://community.anaplan.com/t5/Releases/What-s-New-September-26-2020/ba-p/85429 Tag: @Misbah @DavidSmith @rob_marshall @LipChean_Soh @ChrisAHeathcote
-
Rank and Sort List with Child Items
We have a list within our Data Hub that needs to be sorted in a very specific order. We import this list into several spoke models on a recurring basis and in the past we've had to manually reorder the lists in every spoke model when new items are added (because new items are always added at the bottom of the list). To…
-
How to calculate within specific tenure?
Dear All, I am looking for the best solution how calculate/distribute an amount within specific tenure once it was triggered by a variable. Example: 1 million of revenue will be recognized equally over 24 months once the project is completed. The 1st month of the recognition starts on the following month once the project…
-
Year to Date Cumulation
Is there a function where I can cumulate an amount but reset it to zero when January is reached in the next year (we are using a 2 year timescale)?
-
Line Item Shipping Cost INV01
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
-
Line Item Safety Stock Flag Count
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
-
Monthvalue Formula
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 Growth Rates'.Growth %) - WEEKVALUE('Volume Growth Rates'.Growth %) B. MONTHVALUE('Volume Growth Rates'.Growth %) Thanks…
-
3.3.11 Activity Question
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
-
DigitalCPX 2020: Expert Advice: Formula Optimization with Mark Warren
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 optimization. https://www.youtube.com/watch?v=ujnk0llnsZM We will focus on three key areas: * Golden Rules * Complexity * Text…
-
Week Calculation-Alternate way to put number of weeks in a year
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 number but a derived value from some function or calculation? Thanks!
-
INV01 Line Item;Shipping Cost
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
-
Line Item Override Amount-write?
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…
-
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!