Modeling

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…
L3 Quarterly initial sales target
I am actually stuck in this and need some help 1. In the Level 3 Sales Planning Model I have created a module and successfully imported the data from the data hub for Actual Sales Revenue. Its dimension include - A1 Accounts, P2 Products 2. I have another module in which I have dimension as G2 Country, P2 Product Family,…
Level 2 Conclusion - Import Final Demand Forecast into DAT02 Module
I'm literally at a loss at what its asking me to do here...nothing I do seems to work so I obviously dont understand the question. Please can you help?
Previous Value in a Dummy Time Dimension
Hi All, We are developing a module using a dummy time dimension as the planning needs to be done for a period of 3 months. So just to save the space instead of using Anaplan Time dimension we have created a list with a subset for three months to be used in planning. Now we have few line items as below where we calculate…
Anaplan Summary calculation, conditional formatting
I'm stuck in a particular case. I have a flat module that is is dimensioned by "Test Cases". This module looks to accept attributes for test cases manually entered/selected by the end users. The attributes are Test Case Name, Number, Country, Date, Category etc. Particular line items like Country and Category being list…
Working days between 2 dates - errors with proposed formula
Hello All, I used the suggested formula to calculate the # of weekdays between 2 dates https://help.anaplan.com/21bf8e70-3193-4912-98c6-f25327c11d19-Excel-Equivalent-Formulas and I noticed many errors when the end date was a monday (see attachment). Has anyone else also noticed that? Also, I would like to propose a…
I want to check only April from the period
hi! I want to check only April from the period. The reason is to use the cumulate function. I'd like to check only April in Boolean, is there any good way? As a concrete content, I want to check only in April of FY19-FY22 (month period) I am not good at English and may not be able to communicate well, but thank you.
Combining Line Items with Different Dimensionalities
HI all, I need to do an equation in the third line item that subtracts the second line item from the first one. The issue I am running into is the different dimensionality of the first two line items and then trying to combine it into having the third line item dimensionalized by both lists. I appreciate any help.
Level 2 - Sprint 1 - 1.5.6.2 Import Data into Historic Volumes Module
Hi everyone, I'm having trouble importing this into DAT03 Historic Volumes. I've been at this for 3 hours and I'm not sure what's wrong. Can anyone help? I can't move on to the next activity until I get this right. Thank you.
Set the Export File Name at the time of Export
Hi when running a Data Export I would like to be able to choose what the file name should be when exporting the file via a prompt. In an ideal world I would like to be able to decide on a prefix and suffix for the file name. With one of the options either being the date/time or the value I set in a module. One of my…
Aggregate Subset of Dimension
Hello, I'm trying to figure out the best way to aggregate a line item with two dimensions (SKU and Sales Channel) by Channel. For example, I would like all sales for a specific SKU for only website or Amazon channels. The issue I keep running into is my aggregation line item dimension should only be SKU to save on size,…
Increase end user adoption with smart filters
* Problem statement * How do we solve this with smart filters? * Customer examples * How to model smart filters * Size and performance considerations * Upcoming functionality * Conclusion Problem statement Anaplan users are often moving from an Excel environment (with the flexibility to filter, search, and sort data…
count wrt day timescale
Hello , I/p screen Products start date End DateA11/3/20205/3/2020A21/3/20208/5/2020 O/p Screen should contain the product count and it should look like 1-Mar2-Mar3-Mar4-MarNo of Products2221 Can we able to do this in anaplan?(As the output screen in Day time scale) Thanks Tejaswini
Datatype error?
Hello, I'm trying to get the desired output in (see below or view the attached image). So far what I've tried doesn't seem to work (datatype mismatch). Any ideas on how to solve this?
L1MB-5.2 model maps
Hi, I am facing problems in 5.2.2 model maps overview.I am unable to figure out how to do this step.Please help.
Level 2 Activity 1.4.3.2 Import Data & Add Formula
Hello everyone, I have a question concerning the task 1.4.3.2 in level 2 model building. Why do I have do add a formula to the code line item? I have already received the codes through the import (see picture attached - I didn't add a formula). Thank you in advance! Johanna

Modeling

Discussion List