-
Restrict User Input in a Field to a certain range
Hi I want to get user input in a certain line item related to number format but want to restrict the user input between 0 and 100. If the value input is between 0 to 100 then this value must be used as it is. But if the user input is <0 or >100 then it should return an error or must convert the value directly to the limit.…
-
Level 1 training program Anaplan model builder | Level 2 training program Anaplan model builder
Hello guys. how long does it take to complete the Level 1 training program Anaplan model builder? how long does it take to compete the Level 2 training program Anaplan model builder? it seems a lot of learning material. what is the best practice; (only to fly above as fast as possible)? or take a note of everything that is…
-
Need Help on Line Item Formula Total Beginning Inventory
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
-
line item formula Stock Expectations
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
-
Stock Expectation Line Item
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
-
Timestamp - Current Time (Formula)
Hi there, I realise this is not something new or possibly already somethere out there ... but wanted to raise it (possibly again) to show how important that would be. There are instances that multiple users are using the system. Sometimes there is a case that those same users use exactly the same processes/actions. Given…
-
Check Which Range a Value Falls in, and Return an Appropriate Value
Hello, For each list member in SYS78 (screenshot 1; "Rows") there is a corresponding Baseline value. I want to have the system compare the Baseline value for each list member to the Minimum and Maximum values in SYS77 (screenshot 2), and depending on which range it falls within I want to pull the appropriate Factor. So,…
-
Referencing Switchover Period
Is there any way in a formula to reference the Switchover period for a version? The module is pulling in data from a list across the time periods but if the cell is for a time period prior to the Switchover period, I want it to show zero, else pull data from the list. Thanks
-
Line Item Formula for Stock Expectations
Hi, I used the following formula and it says the dimensions do not match. 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS07 Distribution Center Details'.Country] After that I used the the following formula to have the dimension of P2, and still not correct 'INV01 Inventory Ordering'.Safety Stock Exception…
-
Inventory reservation with FIFO
Hi experts, I’m now struggling inventory allocation with FIFO algorithm. The requirement is automatic inventory reservation with SKU lot level expiration date as below. Automatic shipment allocation/reservation based on lot # orders using FIFO algorithm is needed. I’m trying a lot of ways using numbered list and many…
-
Formula to count the unique values in a column
Hi In the attached screen shot of my dashboard,I want to count the number of unique values in the Item column and display the count value near the title 'Comp Reservation Details'.Any help for the formula/workaround is appreciated. Thanks Regards Prabakaran
-
LOOKUP MAPPING
Hi, For your assistance please. I created system mapping module for custom versions (List: Actual, Budget and Reforecast). Scenario: I want to get the quantity difference of actual vs budget, in my Target module and I also included the custom verions in my applies to. I tried to lookup, apparently the values that I am…
-
Picklist using System module instead of List
Hi, Is there a way I can use a system module as my driver in the picklist ? Apologies, I can't find any related topics on this, please share if there are any. Thanks in advance. Tom
-
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…