Modeling

Import Current Period
We would like the ability to import current period into the time setting. Currently, models need to be rolled over month by month. If we could automate this process, we would have less maintenance debt and be largely hands off as our models update.
Weighted Average in Summary of a line item
Hi - I have two line items, one specifying the weight and the other, say growth. For easy calculations, let's presume that the Weights and the Growth values are manual input. Growth is a manual input only at lower level - say a different line item is created for manual input. Now, when someone views the Growth at the upper…
Exam 3 - A 2019 Actuals
Hi, I successfully loaded the provided 2019 Actuals file and updated the Sales Planning model and I am still getting incorrect answers for the first 2 exam questions which are based on this file. I hit every check point in the Level 3 lesson sprints and successfully loaded the file, so I'm not sure why my numbers are off…
HELP with module setup
Hi hope someone can point me to the right direction. I have a module which Dimension by Agreement Number (xxx1, xxx2 etc) Timescale by month (Jan 19, Feb 19 etc) Line item :Start date : (when the agreement start) Feb16, Jan 17 Etc Line item Income : by the contract for every month I now need to show that data by: Timescale…
Calculation for a value to show every 10th of the month
Hi, We need help trying to write a formula for a value to show on only every 10th of a given month. Also need to consider that the weekends do not count and would fall into the next business day. For example 4/10/2021 is Saturday so would pick up 4/12/2021 instead.
Model Restore from History Logs
Are there any changes/items in model that cannot be restored from Model History Logs?
How to pick up the balance from a previous month
Hi, We are trying to pick up a Line Item Balance from the previous end of the month. For example, for the month of Feb, need to see the ending balance that is at the end of January.
Line Item Subset Summary Level, workaround needed please!
Hello, I have run into an issue for which I could not find any documented limitation or bug, but I think I may have hit one. I am looking for a solution to the following scenario: Let's say I have a constants module, ModuleA, that I am driving a LISS off of. Number1 Number2 Number3 Number4 = (Number1+Number2+Number3) Let's…
Finding the average
Hi, Need help creating a formula that pick's up the moving average for a number within 6 business days. Example) The amount for a line item over the past Weekdays were 1, 4, 6, 8, 9. I want to forecast this by finding the average of those days. Thank you
Import Transactional Data into DataHub
Dear Community, I have a question related to import transactional data (Net Sales) into Data Hub, with the following requirements: * The Net Sales and Qty Volumes are grouped by more than 10 attributes required for Sales Planning Purposes. Best practices in Anaplan is to concatenate those attributes that will be the key…
INV01 not matching up with numbers from CHECK YOUR WORK
Hi, My numbers are slightly off from the Example Model. (I believe like 2 units off). Attached is my Blue Print view and Grid View. Please advice. Thank you
Level 1 Exam - Activity 4 - Employee Drivers by Role - Data Import
Hi, Hope somebody can assist me please so I can progress further on the exam. I am completely stuck after exhausting all options this morning. I picked Column 2 Departments - map to E1 Departments I picked Column Headers - map to E3 Roles I picked Fixed line ltem - to map to EMP03 Employee Drivers by Role Line Items…
Power Function Error
POWER function is unable to calculate all equations correctly. Cube root of '-8' is '-2' But when I tried the "POWER(-8, 1 / 3)" calculation, it resulted as "NaN" (shown in Image)
Level 2 - Sprint 1 - 1.5.6.2 Import Data into Hist...
I am having trouble importing the Historic Volumes. I've tried every which way to map
FIRSTNONBLANK for Numbers
Can First Non Blank formula be used for numbers as mentioned. When i try to, i get an error as follows, Let me know if you are able to successfuly use this formula for numbers. Thanks Arun
Power Function Update
POWER function is unable to calculate all equations correctly. Cube root of '-8' is '-2' But when I tried the "POWER(-8, 1 / 3)" calculation, it resulted as "NaN" (shown in Image)
Hide items in dropdown list
Hi there, I have a list dropdown for our users to select from. However, I am wondering the best way to "hide" certain list items. I want to ensure users don't have the ability to see or select an incorrect item, however I can't delete these list items since they have data tied to them from past years. Attached is a photo…
Difference between Calendar Type options - "Weeks"
Hi Context : In Model Calender, Calender Types reflects 3 different options like a) Weeks: 4-4-5, 4-5-4 or 5-4-4 b) Weeks: General c) Weeks: 13 4-week periods In exl there is "weeknum" to interpret the week number in a given date. Appreciate a clarification on different week formats provided by default. Cheers.
Need help using LOOKUP or SELECT function
Hi, I'm trying to create a line item in the target module that pulls in the values from the source module given a certain day. Attached are screen shots of the modules. Please advise. Target Module Source Module Thank you
Shared weeks (splited by months)
We use ISO calendar split. This mean that a year contains about 52 calendart week and about 63 shared weeks: when a week is located in two months at the same time. This is the only way to move back and forth between Months and Weeks. Currently we have to maintain false Time hierarchy in order to have this option.
Lookup off of code
I need to be able to lookup off a unique opportunity code for line items in a module. Below is the code I need to look up off of, the list is titled MEC Opportunities In this module, I need the line item Opportunity Code (list) to return the above codes while also being list formatted in order to use in lookup functions.…
full line conditional formatting
Hi, If i have 20 line items in a view, i have to conditional format everyone, would be a great idea to be able to format ALL line items using a single line item reference?
NUX pages no longer visible
Hello, I recently had to restore data in an ALM environment. I had to create a New Prod model by copying/archiving Old Prod. I took Old Prod out of deployed mode to capture the data I needed to reload into New Prod then archived Old Prod and stood up New Prod. However, in doing so, the NUX pages associated with Old Prod…
Import Shipping Expenses into OTH01 Module - mapping doesn't display shipping costs
Hello community, I have a question concerning the task "Import Shipping Expenses into OTH01 Module" included in the Level 2 conclusion. The preview of the import doesn't show the numbers of the shipping costs. (in the saved view picture you can see, that I hided the "Code" line item for the export. I did this because it…
Correct MONTHTODATE() for Gregorian calendar
Hi, Does anyone know how I can correct the MONTHTODATE() function when the model time is set to Weeks 5-4-4? The function works perfectly apart from when the month changes during the week. With the current time settings, the second month cumulation starts earlier than it should because it is starting from the first day of…
SPRINT 3 Override Amount
HI. What am I doing wrong in the exam? It wont accept my formula. IF 'INV01 Inventory Ordering'.Submit Purchase Order Request? AND 'INV01 Inventory Ordering'.Override Amount <> 0 THEN TRUE ELSE FALSE
Import without errors and warnings (extra columns in headers and times)
Hi community! I want to bring up the next topic. Best practices and guides suggest that all imports should go with a green check mark, without warning. If there is a warning or an error, then something went wrong and the administrator must intervene. But I found a case where I don't know how to achieve this without…
Export with labels in NUX
I found that in NUX while I export the grid on a dashboard I am not getting options to Include labels in my export like properties or codes we use to get in Old UX.Is this feature not available or I am missing out something in config?
Quota/Tenure mismatch
Hi, I just noticed I have a different Quota amount for Mckenzie Rozell (Sales Princiapal with 2 yrs experience) than from the checkpoint example. Since the Quota is being pulled based on the role and tenure, I looked back at my data it seems to be pulling correctly. Just want to make sure this won't cause any issues down…
Make a copy of our Prod model and make it our DEV Model?
Hi there, I currently have a DEV model that is not deployed where i create a revision tag, push it to our UAT deployed model, then push it to our Production Deployed model. I want to refresh our DEV model with the latest data in our Prod model. I was wondering if i can take a copy of our Prod model and then make this the…

Modeling

Discussion List