-
Upcoming release User list calculations
Does anyone have any additional information on the upcoming release on 4/24 that will allow for calculations to be driven by the User list? This sounds very intriguing, so any intell would be greatly appreciated! https://community.anaplan.com/t5/Maintenance-Notifications/Upcoming-Maintenance-April-24-2021/ba-p/105343
-
Users list and Lookup
Hi Everyone, I have two modules A and B. The module A has one line item formated as a list "Users". Let's call it myUser. The module B's dimensionnality is Users (only). It has one boolean lineitem called myBool. I would like to retreive the value from B.myBool to A. I wanted to use the formula in module A.myBool =…
-
Performance affect of "SELECT:" and "LOOKUP:" used together
Hi community! I couldn't find any information on whether it's recommended to split SELECT and LOOKUP for better performance. This thread helped me to understand that SELECT works in a similar way as LOOKUP (thanks to @DavidSmith for insight). So does it mean that SELECT and LOOKUP can be used together, unlike SELECT and…
-
Dimension Mapping
Hi all, I have some data with various dimensions - one of which includes 'Colours'. I've also got a matrix between Colours and Cities separately (e.g. in the attached) which allocates Colours to Cities on a percentage basis. What I need to do is convert my data using the mapping to go from Colours to Cities. I'd normally…
-
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…
-
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.
-
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
-
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…
-
Is there any way i can convert number to text format but still following the number format for comma
Unable to convert number to Text following comma format, Could anyone help me out of this problem? Thanks in advance
-
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
-
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
-
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.…
-
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
-
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…
-
Summing a percentage of a list amount from one module to another
Here is my situation: I have a module that contains a $ amount for a list of accounts , I am then mapping those $ amounts to another module that contains line items that I have in a List. In my screenshot you can see in Line item Mapto contains values of the list as well as Line Item Mapto2 contains values of the same…
-
Failed to retrieve field list from the selected data source. Please check your import settings and
Hi I'm received this error and it took a while to work out what it was. In the "Source Models" it was pointing to the wrong environment, this is confusing because I could still see the "Saved Views" to click on, it would bail out straight after that with the error. The complete error is: "Failed to retrieve field list from…
-
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,…
-
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.
