Modeling

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
2.3.11.2 Create DEM03 Saved View for Global Demand Assumptions UX Level 2 sprint 2
What am i doing wrong that only one line item is showing in my view after putting filter ? I have put the filter to view months only
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…
Time and Calendars
Ok, I know I am going to open the flood gates here, but we are looking at the functionality of the whole time concept in Anaplan. I'm asking for help in capturing the challenges with the current concepts of time and the model calendar and specifically when we have to use a list to represent time Please could you reply with…
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…
DEM01 Volume Growth Rates Sprint 2 level 2
How to add this filter? Also why not use show selection then filter
Level 2 sprint 3 Build Distribution Summary
As per the activity I need to display Stock Exceptions I am able to get Stock Exception for a product according to the Distribution Center But, I am failing to display Stock Exceptions for all product in All region, though I have Stock Exceptions data in INV01 Module
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?
How do I create a reporting forecast FTE module based on a time-dimensioned actuals module?
Hi, I have a monthly report for employees actual FTE, start date and leave date. I import this into a module: * Dimensions: People, Time * Line items: FTE, Start Date, Leave Date The forecasting for future month should be: Previous total + New joiner that month - New leaver that month. So if I look on the September data my…
Update Historic Volumes for Baseline Forecast IN LEVEL 2
Why am i getting error while updating the formula?
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
Level 2 Sprint 2 2.3.10
My DAT03 works perfectly, but sometimes it shows as Zero on the Offset Volumes. I think this is because the formula being too heavy. It is funny as I think I did a work around instead of the required formula for DEM03. I am not sure if this is the right answer or not. I imported instead of a formula for FY20 for DEM03.…
Save tabs & reopen tabs
As Model builder, I work with multiple modules and dashboards. After lunch or in the morning I need to search for all modules and dashboards I am working with and open them again. IDEA DESCRIPTION: In case I want to continue working with same modules and dashboards, I just click "save tabs" before closing my Google Chrome…
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…
Undo
Description: Provide 'Undo' functionality throughout product. Could consider only allowing one two 'moves' backward. Could also consider limiting to data changes if needed. Impact / Benefit: This would greatly help our user experience in quickly reverting a change we make.
Dragging row/column headers to resize
In the current client, columns are resized through a dialog where numeric values have to be entered for each column. The proposed enhancement suggests enabling dragging of headers to resize them in a more efficient way.
level 2 prepare for sprint2 activity
Not sure which saved view have to be imported from Data hub model?
Value from wrong version is returned
Hi, I have a problem where I get value summed by a wrong version returned. From a module without any versions, I want to pick up FTE values from budget version in another module which has versions and sum by which role the employee has. The formula looks like this: 'FTE Module'.'FTE'[SUM: 'FTE Module'.'HR-Role', SELECT:…
Period shown module automatically update when i update the time selector
Hello, Is there a way I can automatically change the shown period in my module when I change the time selected? See screenshot attached. I need to show the period in each line item. Thanks, Tom
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)?
Page breaks on auto-email links "mailto:" syntax Makelink formula
Hello everyone, I created a line item and formatted it as text/email so I could create a link on a dashboard to email approvers. It pulls the approver's name (code-which is email address), puts in a subject, and writes the email which changes based on risk level, High/Med/Low. Then writes in the description of the project…
Level2 Sprint1 model builder user story 4
My actions tab have following 3 actions extra as compare to view shared .They have no related processess may I delete them
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

Modeling

Discussion List