Modeling

Why does the formula change when we change the Time Range from CY and PY to Last 5 yrs?
Why does the formula change when we change the Time Range from CY and PY to Last 5 yrs?
Community perspective: RANK and row counts – Management Reporting with multiple lists
A common request within any planning project is to create well-formatted, standard reports for the business to consume. However, these aren’t always as simple to create as first thought. The Management Reporting capabilities within Anaplan produce great looking outputs. However, they require a fixed number of rows for each…
Issue in Level 2
Hello Community , Facing an issue in Level 2 1.5.7.1 Create SYS13 Account SKU Filter Module In this I am unable to create ---- 1.5.7.2 Add Formula to SYS13 Line Item where " * The formula should check the total of all product SKU volumes over all time periods to determine if the value is not equal to zero." Can Someone…
Create Sequential Code for New Activity
Hi Team, I am trying to create automated code for the new activity I added to a numbered list The format should be like this: Department code - Activity Sequential Code (the structure attached for example) I've tried to make a system module, but the activity code still has duplicates. Is there a way to make automated code?…
2.4.6.2 Apply Dynamic Cell Access to Demand Forecast
The Override forecast line item won't accept the formula? What am I doing wrong?
Model change has been rejected to prevent the workspace exceeding its size limit in supply chain
IM GETTING THIS ERROR WHILE CREATING A NEW MODULE IN THE SUPPLY CHAIN FOR L2 SPRINT 4 Model change has been rejected to prevent the workspace exceeding its size limit Current model size: 637670764 Rejected model size: 720294076 Current workspace size: 1023483953 Workspace limit: 1073741824
Level 2 - Sprint 2 - 2.9.3.2
Hi In my Supply Chain model, I'm trying to run the action which inside there are 3 processes: with the 9.1 import action is the new action I previously did But when I run the action, it shows but this model is something I downloaded from the anaplan. What can I do to fix that? Thanks
Level 2 3.3.6 Confirmed Purchase Order Receipt shows no value???
I can't get the value or in others words add the numbers in the Suggested order amount of the month. The line item always shows 0 no matter how hard I try. You can see my formula on the formula bar. Where do you think I have done wrong?
Switching to/from Numbered List
Are there any risks to converting a numbered list to non-numbered, then back to numbered? Scenario: I have an Employees numbered list with a 'Display Name' property. There are 100+ members not in alphabetical order. An existing workaround for sorting non-numbered lists is to export the list to Excel, sort offline, then…
MailTo Formula Adding %'s to Emails
I'm trying to create an email list to send out to our end users. i used the TextList function to pull in all emails from a line item in a separate module. i have tried using both Commas and Semi Colons as separators. This line item is formatted as Text General. The emails seems to populate ok in this line item. (i have…
Search if a list member exists in a text line item
Hello! I got a Invoices Data Load Module that gets its data from a numbered list "Invoices". The line items (invoice number, client, comment, amount, date etc) are the "Invoices" list properties. We started selling a new product last month, but our ERP doesn't fill the "client" field in the invoice when it has that product…
L3 TAR01 Module and it's check Module
Having trouble seeing why my check is not coming through for my TAR01 module. Attached are screenshots. Thank you
RANKCUMULATE function not working with a negative number
I have a RANKCUMULATE function that is working fine but when a negative number is referenced it ignores it rather than subtracting it from the running total. I am hoping someone has run into this before and has a solution for me.
Stuck on sprint 2 Question 5
Hi, I have attempted the exam multiple times now and cant get out of the first and 5th question on Level 2 sprint 2 exam. I have reviewed all available resources on Roles, Selective Access, Dynamic Cell Action and WORKSPACE Adminstrator Many times and still getting the Question wrong. Please help anyone. My email is…
STUCK on 1.5.3.1 Create Filter and Saved View for DAT01 Module
Hello Can you help meplease i'm stuck on 1.5.3.1 Create Filter and Saved View for DAT01 Module I can't create a filter for this activity, And i can't have the same disposition like other learners and i don't understand my screnn:
[First Look] Pages Interface: Modules
Feature: Pages Interface for Modules Release Date: September 2022 Impact Assessment: Better alignment with UX pages What is changing? A new tab is available in the Admin screen of the Pages interface called Modules, which lists the modules used on that page. Those names can be selected and will open the modules as a new…
1.6.2 Activity: Import Data into the Shipping Metrics Module
I am getting the error in Time . I completely stuck , please help. This error is coming while uploading Shipping Metrics CSV file. I also tried ??YY for solving Time error but it was not resolved. Please help.
Uniques Identifier as code for a Numbered List
Can i Use Numbered list Unique identifier as a Part of code for Numbered List?, How long can a Unique Identifier can go? I have a numbered list Named 'Activity List' under a Customer List as its parent and I am Planning to use Unique identifer as a code for that List as Name(Item(Activity…
Line Item Override Amount-Write?
Hi, I get the results I want in my Model with the following formula, but in the Exam it is not accepting my formula. Is my Syntax incorrect? IF 'INV01 Inventory Ordering'.Submit Purchase Order Request AND 'INV01 Inventory Ordering'.Override Amount <> 0 THEN TRUE ELSE FALSE Thank you
User Story 1.6 L3
Hi, I can not get my module to populate. Please advise. Thank you
Identify records with same value in Column 1 but different value in Column 2
Hi Team I need to identify records that have same value in Column 1 but different values in Column 2. For eg, from the below data set, I want to identify the 1st 2 records may be by adding another line item NameCodeTimelineRoger F1MonthRoger Federer1QuarterRafael N2MonthRafael Nadal2Month Thanks
1.3.15.3 Check Your Work Level 2 Model Building
I am unable to add the action to processes. Please find the screen shot attached here. Earlier i was facing issue with adding the flat list also but i was able to add it after so many trials( 5.1, 5.2,5.3). Please help me to understand how to add the 5.4, 5.5 .
Time Filtering
Hey all, I'm wanting to update a time filter to use in module views but am having a hard time figuring out how to create a specific condition. I want to have a filter for the current quarter and the previous five quarters as well (so 6 quarters total). Right now I have a line item that gives each quarter a decimal value…
create shipping export module and create a saved view
Good Evening, In the last part of Level 2 anaplan, activity "prepare data exports", we are asked first to create a module to export later ( easy and done). But then in the same sentence they also ask to save a view for export, but they don't indicate what to pivot, if there is any filter... I don't get what to do after…
Cycle Shift Input Design
Hi Everyone, I am trying to design a module for shift input. It should be working in this way. When we enter shift start time and cycle period, that start time will repeat according to cycle period until we override it. I am struggling to design and figure out formulas? Any idea and tips are appreciated. Thank you.
Budget based on prior year outputs whilst avoiding circular references - help needed!
I have some minor account / cost centre values that I want to flex year on year based on the % change of a proxy and inflation. The solution I have tried below is creating circular references in the final part: Year 1: Period 1 Base value (final month of actuals) Inflation % Period budget (base value * inflation %) Year 1:…
L3 TAR01 Module
Hi, My TAR01 Detailed Sales Target is off. I'm not sure why. I tried to pull from D02 Data Module, but then my dimensions were wrong and wouldn't let me look up by product and country. I have been stuck on this one for a while. Please advise. Thank you
Filtered Summary View based on the presence of a list member
Hello, I'm stuck on the logic to create a filtered summary view. I have a table A, but now want to create a filtered table B (which is a list of only the cost centers & Worker Type combination with a Large Group Size (i.e. Headcount total of 21 & above across all Work Groups.) So in the image below: The summary view (table…
Renaming P3 SKU list from Saved View_ 1.4.6.1
Please help me in renaming the P3 SKU list from the saved view. 1.4.6.1 Rename Actions Using the recommended naming conventions for Actions: * Rename the Actions used to load the P3 SKU list and SYS12 SKU Details system module:* Organize the Actions in the correct sequence. * These Actions will be included in the Process:…
Scenario for calculation
Is there any formula instead of first occurance

Modeling

Discussion List