-
Average of Daily Data
I am building a new model and have daily data. Our data is only for weekdays though. So when I use the average Sum method Anaplan averages in a zero for Saturday and Sunday which is obviously not what is required. Seems like there should be an option in Model Settings/Time to allow me to define what a week is but there is…
-
Invalid Parent While Importing in List
Hi, I am trying to import a product list which is a numbered list form another model say ICM. But while trying to import it,it shows the invalid parent entry.However the list is getting rolledup to the correct parent. Screenshot attached.
-
Filtering only summary items
Hi, I have a list that is used as rows in a module and the list has a parent hierarchy. I would like to filter out only the summary items when publishing to a dashboard, but can't seem to find a way to do that. What I tried to do is just set a value of 1 for the list items and then filter everything that's greater than 1,…
-
List
* I want to ask about List. i want to take code on Account L0 Flat List to Account L0 . Account L0 FLat is list format .. *
-
FINDITEM formula
Hi all, I have a list named "TAT Hours" and a line item "TOTAL HOURS" that is in number format. I used FINDITEM formula to get the number of hours (TAT Hours) in the list, here is the formula: FINDITEM(TAT Hours, TEXT(IF TOTAL HOURS <= VALUE(NAME(TAT Type.Min Hours[LOOKUP: 'TAT Type1'])) THEN VALUE(NAME(TAT Type.Min…
-
Optimizer Overview - Not Showing Correct/Optimized Results
Hi, I have a simple LP problem where in I need to check how many Units of Big Products and Small Products can I make in order to maximize my profits keeping constraints in mind. Objective : Units to Make for Big and Small Products Inputs: 1. Manpower for Big is 6 Hours and for Small it is 9 hours 2. Raw Materials is 1 Bag…
-
Line Item Subset for Text Formatted line item
Is there a workaround for selecting a non-number line item in a Line item Subset? I've created a filter for increasing and decreasing the number of lines shown in a dashboard table using David Smith's outline in this…
-
Intermediate Model Building (OnDemand)
Am doing activity 20 scenario selection.How do i make the selection dynamic.this is how i mapped it.
-
Intermediate Model Building (OnDemand)
When i test for Brad Bonson i get CRE as well but looks like am only supposed to get CAE.Cannot figure out where i messed.
-
Dimesions
What is the difference between Built-in and Default Dimensions?
-
Section 12, Activity 17 - Ramp Line Item
Why is ramp format a number and not percentage?Am trying to appreciate the formula and output on this line item.
-
how to resize 'Published selected items to dashboard'
Hi, I published line item to a dashboard as page selectors using 'Publish selected items to dashboard' But I am unable to align the published line items. Now if you see Effective Commission Rate is appearing in 3 lines, but I want it in only one line. How do I do that? Thanks, Vamshidhar Reddy
-
Version formula
i'm using three versions in my module, here Actual, Forecast, Budget. i have the actual and budget data available and they can be manual entry data. Forecast data should be formula given. Actual Budget Forecast Jan Forecast Feb ---- until Forecast Dec Thank you,
-
Version Formulas
i have a question, on my project i have many versions such as Actual, Budget, and Forecast(Jan-Dec) . on Actual and Budget version will input by user but for Forecast this will retrieve data from another forecast module version? how is it done?
-
Abnormal increase in size and performance reduction due to multiple Versions
Hi All, I am currently seeing dramatic increase in size of the model probably due to the usage of the version. Due to the problem I am trying to solve I require many versions (upto 100). This leads to the model size increasing 10 times as fast as using other normal lists as dimensions. for example my mode has 17Mn cells…
-
102 Certification Employee Costs: Salary VS Gross Pay
Hi, I am doing 102 Cert for Employee Costs. Did anyone have any idea the different between salary ans gross pay? We cannot find any info on gross pay. Thanks!
-
Formulas
What is different about LOOKUP and SUM?
-
Rankcumulate till previous Rank
Hi All, In simple terms I want to know the total till the previous rank complicated by the fact that the last number depends on the rankcumulate till previous rank. Hence this is giving rise to Circular references. Let me give an example (see attached) * I have sales volume of SKU by date dimension ( though this data is…
-
FORMULA
HI Experts, We have line items Line item:1 : FCST_1 Line item:2 : FCST_2 based on FCST_1 convert into Rounded value. Both line items are text format. First item data in dot(".") format but we need to convert comma(",") And we need round off the FCST_1 line item. For suppose FCST_1 = 1.2498 then by using some formula we…
-
Formula Structure for Performance
how to create best formula for using IF ELSE?
-
How to create formula that calculates the first child of a given parent?
Hi, I need to map high level data (Product) to leaf level (SKU) for exporting planning information to transactional systems. Each product has multiple SKUs so we'd like to automate that mapping by using the first SKU within the hierarchy. I can calculate the SKUs sequence within each product using RANK function but I'm not…
-
Saving a module view in deployed model
Hi, When I try to save a model view in deployed model, I get a message saying "Deployed mode is enabled for this model. You do not have permission to change structural data. I have "Full Access" to this deployed model. I was hoping that there is functionality to allow users, especially those with Full Access, to be able to…
-
Find 5 Saturdays in a month using Date functions and not Calendar type
Hi, I am trying to create a boolean flag that will tell me if a month has 5 saturdays or not. Can someone guide me in constructing this with date functions? Unfortunately, I cannot change my calendar settings to 4-4-5 etc because of business restrictions, so I have to calculate this manually in order to adjust and smooth…
-
Intermediate Model Building - Req Quota Module - Goal calcuation is not working
I've entered this formula for the goal calculation. IF Active? THEN ROLE GOALS.Quota Goal[LOOKUP: Region, LOOKUP: Role] / 12 ELSE 0 I'm getting this error. Dimension of mapping used for lookup doesn't match any dimension of the result Has anyone else run into this?
-
formula generation query
Hi, For suppose there are 2 versions in a module. Then how to write a formula for particular version. For instance , 2 versions named forecast and actual & a line item as Units sold. How to write a formula which is only applicable for units sold in the forecasted version(only one)
-
SUM vs LOOKUP vs SELECT
Hi everyone, Capps Europe and Advanced AnalytiX have made a video on how to use SUM, LOOKUP, and SELECT functions in Anaplan. The way these functions work is quite different from Excel, and hence they may often be confusing for beginner Model Builders. I hope you will find this helpful. The video is available here.
-
Is there an ELSE IF or Switch statement in Anaplan
Hello, I am trying to create an IF statement with 3 possible answers. I was able to do it in excel using this formula: IF(C2="SUPPORT",0 IF(C2="BILLABLE",1,IF(C2="FREE",-1))) But I was wondering if there was a way to do it in Anaplan so I can use the conditional formating with text rather than numbers. Thanks
-
Sum parent only for items where I have access to
Hi, I'm trying to create a sum on parent level, that only includes the items where I have access to. I attached an example. The only way I can think of is to add the users as a dimension to the modules and create an extra line item that only gets the number if the user have access to the item and then use this extra line…
-
Eliminate pop-up box for all records when creating new record
Hi, I created a numbered list "record List", it will have the records that the user will create. Record list has "All Records" list as Parent. "All Records is just a list with one record. And created an action which will add the new record to the numbered list. While creating this action I gave I gave the following…
-
Push Boolean selection from input module to detail module
Thanks in advance for the adivce... I am trying to push a boolean selection from one module to another. Let's call them input module and calculation module. The input model sits at a hierarchy several levels above the detail module. Input Module has not time version or time dimension and sits 3 levels above in the…