-
issue in populating data
Hi Members , I am still facing an issue where in I have to populate FY WEEK 20 forecast with the Actual volumes of FY WEEK 19 ( ALL weeks ) I have used the below mentioned formulae IF 'SYS01 Time Settings By Week'.Current Period? THEN 'DAT03 Historic Volumes'.Volumes ELSE 0 Also used IF 'SYS01 Time Settings By…
-
Level 1 Activity 5
Getting an error for dimension of mapping used for lookup doesn't match any dimension of the result.
-
3.3.6 Activity: Test the Shipping Cost Formulas
The Final Shipping Time Weeks is right? Why is it not 1 in my module?
-
Further help, with what should be a simple lookup
Hi, I have a ranking module as below This shows the top customers and some data changes ranked, also there is an image for each customer Now I have a module where I need to store the top 5 customers images to feed a business report A simple lookup in Excel, looking up 1 ,2,3,4,5 etc but for the life of me i can't figure…
-
Fetching Start Month and End Month for a given Quarter
Hi all, I'm trying to fetch Start Month of a Quarter input by the User. I created a line item for input by the user formatted as Time Period Quarter and another Line item formatted as Month. I tried multiple ways and looking for help to fetch Start Month (say for selection of Q1 FY20 - looking to fetch JAN 20 similarly for…
-
Level 1 4.6.6 Activity: Import Data into P1 Product Family List.
Hi you amazing community 🙂 When I import the data for P1 list and map it, I either get an error that family name doesn't exist (chocolates doesn't exist), or CH maps under chocolate, etc. There's also no option for parent mapping. My grid doesn't look like the training instructions and I'm stuck. Thanks so much in advance
-
3.3.5.3 Check Your Work
The method and Shipping Time weeks are not getting populated in my module. I don't know why? Help me resolve this?
-
Rank using Unique Item
Hi, I have a module which shows change in volumes by Customer - Product (over 5000 lines) I then rank these changes largest to smallest, and have a view of that. Customer ProductLast MonthCurrent MonthChangeRankCustomer A - Product 1340,480311,576-28,9051Customer A - Product 270,32646,326-24,0002Customer D - Product…
-
Level 2 - Sprint 3 - 3.3.5.2
Let me know, if what I did is right or not Create a Filter You will need to create two Boolean-formatted line items in the SYS01 Time Settings by Week systems module: * Line Item Name: First Week of Timescale? * Use this Boolean-formatted line item to select the first week of the timescale. * End users can manually select…
-
Level 2 - Sprint 3 - 3.3.5.2
Can I get help regarding this? This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week. The syntax of the formula should be written: If it is not the first week of the year, then use…
-
Weekly subtotals for model with calendar type M/Q/Y
Hi, colleagues! Do you know any elegant solution for entering weekly subtotals or week ID's into module of model with calendar type month/quarter/year? Cause I faced such issue: FP&A team wants a module for calculating daily sales plan - that's ok, but another step of the process is review of that plan by BU owners who…
-
Use Gregorian calendar week numbers instead of fiscal week numbers
Hello community, Currently Anaplan uses its own week numbering to determine the week number. When fiscal period is different from jan-dec, then week numbers do not match at all with calendar week numbers as defined in ISO 8601. This makes it very confusing for users to adapt to these new week numbers, especially when users…
-
Incorrect Sum Total
Hello, I'm running into what appears to be a rounding error, however I'm not using any rounding formulas. We have a total of 625 employees being allocated across different locations. In the Total Allocation column from this module, my sum is 625: When running these allocations through a sum by location ('STG: Employee…
-
IS IT POSSIBLE TO LOCK THE ROLLING FORECAST?
Hi, I would like to know if it is possible to lock or save the rolling forecast for the remaining months of the current year?
-
NPV Function cannot get what has been provided in the technical document
Hi all, I tried to replicate the example in the Anapedia link However, I cannot get the same result as in the example as below. My module as below, my result as highlighted. Even the same cash flow data, same date column, and same formula with hardcoded discount rate. What do I miss? any idea? Thanks.
-
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: