-
Auto generation of Code
Hi everyone, We have list of Activities that are being uploaded in a numbered list with Activity Description and Expense Group as Unique Properties. Requirement is to generate Code in Anaplan based on Activity. I've tried different approaches but not able to fulfill all criteria Example: - Activity DescExpense GroupAnaplan…
-
problem in using lookup statement
in sprint 3, i have been tasked to create a country summary output module with G2 Country and P1 product family as dimensions and stock safety flag count as line item. The line item will take data from inventory module which has stock safety exception count as line item and put the data in country summary module. Now the…
-
Lookup funtion return blank values
Hi, I have the 2 modules below and did a lookup function but it returns blank values. Am i missing something?
-
Need help avoiding Circular Reference Error while using POST formula
I am working with a system that calculates what payments should be, then when the actual payment is made we record what that value and save it back into the model. Sometimes there are retroactive changes, which cause a variance between the calculated and the actual amount. We want to be able to post the variance to a…
-
OEG Best Practice: Inside the Hyperblock
What are blocks? How blocks are calculated – General Lists How blocks are calculated – Native Time/Native Versions Hyperblock performance Summary block counts Should I worry about blocks? A reason why we shouldn’t focus on just the block count Focus Points We recommend this article to Experienced Model Builders and…
-
How to know current User ID
Hi, I am trying to create a DCA where in the requestor should be the only one to be able to Submit a request. In this example for this module, I am logged in as user id Camille@abc.com. since the requestor is Mark@abc.com, the Submit checkbox should be disabled since me(Camille) is not the requestor. Is there a way to do…
-
IF Then Else Issue
I want the Repair and replacement = Flat terminal then 1 else o (or) True else false No getting the result
-
IF then Else issue
I am Having two list formated line item, NOw i want chek true or 1 base on the one list item to other list item how can i acheive that
-
Parent hierarchy & Top level
Hello fellow Anaplanners, I have a query, I was going through an existing model and where I saw there are multiple composite hierarchy built having just 2 lists. i.e one is parent list (say 'X') and another is child list (say 'Y'). Now here in first list 'X' (which is parent for the other) there is only 1 member 'All X…
-
Hey, How can i Autogenerate Codes in a Non-Numbered list?
-
Statistical forecasting App in UX
Hi all, I can see that there's a statistical forecasting App on the App Hub that can be downloaded but it looks like everything is in Classic dashboards. Does anyone know if there's a version of the app that uses the UX? Thanks
-
Lookup Sales Based on drop down list
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store. Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store…
-
View access based on User list
Hi, I have a module where users create New Cost lines. Since the security is based on Groups, users can see costs created by other users within the group. Now the ask is that users should see the costs created only by them, for example, User A would see cost items created only by A, B should see only B's lines etc. Note…
-
Pulling value from another line item in the same module
Hi I have an Emp List. An employee can have 2 records in the list (the 2nd one with an extension ABC OR). I need to pull the values of the 2nd record in another line item of the 1st record. Could you please suggest how to show the values in Red below? Thanks Is ABC OR?Projected salesABC OR SalesJohn DoeY1000520John Doe ABC…
-
Summary Settings in module Blueprint view
I'd like to know the difference of Summary settings combination in the blueprint view between: Summary- Formula, Time Summary: Same as main summary vs Summary-None, Time Summary: Formula If possible can anyone explain me with a small sample data like this:
-
Pricebook to flow down from Parent to Child
Hi, The above are currently in the system where L4 is a list of distributors. I do not want to touch/amend since i am new to Anaplan and do not want to mess up anything. I created a new list as below; I have created a system module to link L3 distributor to L4 Customer in the earlier list. After which, I have also created…
-
Applying different formulas to list
Hi, i'd like to ask about how to apply different formulas on each item in a list. As You can see, Module 1 shows actual data from the current month. Module 2 is a forecast module, where the baseline column is from the previous month actual data, while the Growth % and Growth column is an input column for expected growth…
-
How to create a module where i can link existing module to a new list
Hi! Not sure if the subject header make sense but here it goes. I have a existing module that have pricing by distributor by month by SKU, example and lists used as below; Different distributor will have different prices by SKU The above are currently in the system which i do not want to touch/amend since i am new to…
-
Date function not working
Hi, I'm trying to convert Open date line item- text formatted in to Date using Date function but getting blank in Date Final line item, could you please help me where I'm doing wrong
-
Open Source model in Formula bar
Drilling down gets exhausting. When you are in the module tracing a formula, when you click the chevrons to bring the formula window to the bottom of the screen, functionality to be able to right click a formula and a window opens to give an option to "open source model" just like in drill down would be awesome.
-
Lookup two different dimension
Hi, I have attached a sample Modules that I have in my model: I want to retrieve the Quantity data from Module 1 to Module 2. but they have different dimensions. As you can see below, the dimension for Module 1 is Unique Code List, and Month (time) but in Module 3, the Dimensions are Active Skus , and Accounts. I tried…
-
Sales bonus based on hire month
Hi, I have a requirement to have sales bonus based on the hire date - For example, if an employee is hired after sept of 2022, the employee is eligible to get sales bonus only after Feb 23 onwards. If the employee is hired after sept 23, then s/he is eligible only after Feb 24, etc.. If the employee is hired in or before…
-
Time functions Polaris
Item(time) function not working in Polaris my time scale is month. Format is year. need to populate year Thanks
-
Formula help
I have 4 modules as shown in the screenshot. When I make an Override only for Brazil it is being carried into all of LATAM in Module 4. In module 4, the revenue is pulling for all the countries when in-fact it should pull only for Brazil. How do I fix it?
-
Display SKUs based on selected Type(parent)
Hi, I have a module name : NPI Enrolment -- this is to encode New SKUs which currently is in a separate list called New SKU(List) I also have another module called Reference Sales -- the goal is to get the sales from existing SKUs since New SKU have no sales yet. In my Reference Sales Module, I cannot display the SKUs…
-
Ability to update formulas of List Properties just like line items
To use the List property in formula, one need to type out the whole list name including property name, that is a cumbersome process. Allowing Reference of List Properties, will save MB time and efforts in wrong typing of name.
-
Searching for a certain role
In my data I have teammate roles, their names, the month that they were in that role, and the facility that they serve. In one module I have all this information listed out. I included a picture with the data I have. I didn't include the teammate names because that is sensitive data, but there is a column left of facility…
-
Sum calculation not visible when highlighting cells in expanded view
Currently in an Anaplan dashboard, if you highlight cells, you can view the summation of the values (see image below). However, when you expand the table to fullscreen, the summation does not show (see image below). We kindly request a product enhancement to allow for summation calculations in an expanded table view.…
-
How can I get the average of months for prior year?
I would like to get the averages for a line item using prior year month values. I can use the formula below but I don't like the idea of hardcoding. Is there another way I can do this without hardcoding? The current formula I have is: LAG(<source LI>,12,0)+LAG(<source LI>,24,0)+ LAG(<source LI>,36,0) / 3
-
SYS07 Sales Rep Details (Length of Service List Line item)
Hi, having trouble to find out why some of the result are blank Thanks, jehular