Modeling

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
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…
Level 2 Sprint1
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 help is needs from System module?
Line Item Format: List - Able to select any member if list hierarchy?
I am using a composite List hierarchy: L1 List (Parents) >L2 List (Parents) >>L3 List (Children only) In a module line item, I format a line item to Type = List, and List = L3 List When I choose the pick box for that line item in the module, I can choose any member of L3 List. The members of L1 List and L2 List appear in…
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
Sprint 1 Dat 03 Historic volume
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 doing wrong?
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…
Store RUN LOGS and ERROR LOGS for automated actions
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 everyday morning at 6am). Is there a standard functionality to track all the RUN LOGS and ERROR LOGS for automated action? If…
Need help in setting the column
Hi Need help in setting a column up in our module. We have four separate columns , Cons_Last Month, Cons_Last Quarter, Cons_Last_Half Year, Cons_Last_Year, which are the numbers of past historical consumption quantity of a particular sku. For better presentation, we want to show all these under one column header '…
Accidentally deleted a module formula
I deleted a formula which I don't want to write again, is there no way to undo the deletion? Control+z is greyed out.
Need help in fetching last quarter /last half year
Hi I am trying to use a formula to fetch the last quarter and last half year. I have a line item 'Current Quarter' in my module which has the current quarter. ex.Q3 FY20. I want to apply formula on this line item to get the last quarter and last half year values. Any help is appreciated . Thanks Regarrds Prabakaran

Modeling

Discussion List