-
how to create boolean boxes for user to manually to check on
Hi, I have a list of opportunities and would like to create a Boolean column for user to manually check on. I would then like to filter the list where all the opportunities are being checked off (Basically to filter the list where boolean = true) It would be best if this can be done in the NUX where the user can check on…
-
Bulk copy action
I am having one requirenent where i need to copy data between versions of one department and one product combination data ..how can i achieve that
-
IF statement help
Hi, I need some help with my formula - separately they are fine, but it doesn't quite work when I combine them together. In the consol I had initially just combined the formulas in A, B & C but it did not work so I then changed the formula slightly (see below). What should the consol formula be? Thanks AIF Line item A = X…
-
Variation Column that results "%" or "pts" in the same cell depending the account selected
Hello Everyone I'm trying to find a creative way to report the line items in rows and columns with amounts, variance $ and variance %/pts (the last in the same cell). In the screenshots below is the ideal formatting. Unfortunately Anaplan allow me to use only one Line Item, so I cannot create customized columns and be…
-
Pulling in data from a monthly module into a daily module
Hi, I'm trying to write a formula in a module that is time dimensioned as Daily, but the module I'm pulling the data from is monthly. How can I get data to come in. Basically I'm trying to break down the monthly information into daily. I do not believe a subsidiary view will work. Thank you
-
Customer to Distribution Center Mapping
Hello, I need to map specific customers to local DCs in a region. Rather than a 1-to-1 relationship, each customer could be serviced by multiple DCs. A) I've created a Customer Forecast module that contains customer demand data by customer, product, week. B) I need a mapping module that allows the end-user to make local DC…
-
List Subsets vs LISS
I am new user trying to optimize mapping a model to avoid the issue with multiple IF/THEN formulas described in the following link. I have been trying to map my model using list subsets, but found the article deals with line item subsets "LISS". I would like to understand if this methodology based on "LISS" is also…
-
Calculation Query
HI. I'm struggling to understand why I am getting a zero answer on my pension row. Please see June 21 as an example.
-
Looking for a neat way to create a histogram in Anaplan
I am currently looking for a way to create a histogram out of a lot of simulated data I have created. Basically the application runs a full Monte Carlo Simulation and I would like to present a histogram of the Results. I have those results in a module with the "Simulations" list (lets assume it is all in one line item).…
-
Data Check
Hi, Is there a way in Anaplan to check if the list member has data in any module we have ? Thanks, Tom
-
INV04 Distribution Center Capacity Model: Beginning Inventory
Hi All, For some reason my Total Beginning Inventory in INV04 Distribution Center Capacity values don't look right. You can see my formula in the image below. It's basically saying my total beginning inventory is 137% of my distribution center capacity... Yet if I go to my DAT01 Beginning Inventory module, I can see that…
-
Build a model
I want to build a view to see sales for the year 2020 using products and customers dimensionality. Customers are spilt as active and inactive customer. Any suggestions for it??
-
Formula that will allow me to divide a child by the parent
Hi, Need help creating a formula that will divide a child in a list by the parent. screen shot of the formula I have Looking to take the Amt from both Direct & ISO and divide them by the All BU parent from another module in their specific columns.
-
Line Item Subset Lookup
Hi, Trying to look up a Line Item Subset to use in a formula. Example of the formula is as follows. IF ITEM(LISS C67 Commissions)='LISS C67 Commissions'.'52053 - Internal DS rep commission'THEN 'R18 Lending Summary'.$ Funded/'R18 Lending Summary'.'Total Cash Collections*' ELSE 0 Formula is not going through because using a…
-
Calculation Logic across Time dimension
Hi, I am trying to achieve the following output in Final Value line item. 1) Till the first override the system should take the Value line 2) Once Override is checked, the system should take the override value and copy it across the remaining timeline unless a new override is done Can someone please help in defining the…
-
Check the first day of every month.
hi! I want to create a line item in a module with a time axis of Day, where the first day of each month is checked. What should I do? Please help me.
-
Formula to Select data based on Month
Hi, I am new to Anaplan. I would like to have a formula that pulls data from module A if the month is earlier than say Feb 2021 and to extract value from module B if the month is from Mar 2021 onwards. What is the formula to do this please? Thank you.
-
How to map/allocate product cost over time based on flat data?
We are doing a project around Margin by SKU and I am having trouble mapping/allocating product cost to a dynamic Time dimension. Attached is what our flat cost data looks like. DL is the location, 14190 is the item/SKU, and the 11/12/W1 are different cost types (variable, variable + labor, etc). We've got the cost and then…
-
Map Result from System Time (Days) to Customer Days (Fake Days)
Dear Anaplan Experts, I have below module using Days as time dimension. I also have a line called fake days where I mapped the system days to a fake days list. Then I would like to do a LOOKUP to pull the data from the above module to a module with the fake day list as dimension. Time is not a dimension. THanks for your…
-
String binding
hi! I want to concatenate the strings! When displaying the time, I want to use "hour" + ":" + "minute"! Example: "9" + ":" + "15" → 9:15 I'm not good at English, so this may be difficult for you to understand. Thank you!
-
remainder of division
hi! I would like to know how to calculate the remainder of a division. Example: 5/2 → 1 , 45/7 → 3 Thank you!
-
Modeling
HI, Can someone help the below requirement. Need to get Prior year data, I know to use offset or lag, But for FY, I need to get the data what i have in the prior year (FY) only, when using offset or Lag , I cant use any other summary except "sum". Any help would be highly appreciated. Thanks
-
Moving Average in Custom Timescale
Good Day!! I have a scenario where I'm trying to calculate the moving average from actuals in Custom Day time scale. In a module, I have sales data to be uploaded, from the sales data I have to calculate the moving avg of 90 days at the day level. Dimension in the module Article, Custom Day scale. Line Item -Sales Qty,…
-
Break Back
How can we apply break back to the line item that is having filter, for example I have one list with list items 1,2,3,4. In a module I will use this list as a dimension and will apply filter which will show only 1,2. now if i enter a value on parent then it has to split between 1 and 2, but it is happening like splitting…
-
Spreading amounts
Hi Anaplan Experts, I'm not using native time and wanna use the SPREAD function. However, This function needs a time scale. Some functions can't run in custom time, such as OFFSET, LEAD, PREVIOUS, ETC. What are your thoughts on calculating asset depreciation with the LOOKUP function?. Kind Regards,
-
Formula error
My formula is not working. Here is what I have: IF 'Sales Trend V4'.'2019A' = Gross Sales.'2019A' THEN 'Sales Trend V4'.'2019A'[SELECT: GL Name Sales.Sales] / 'Sales Trend V4'.'2019A'[SELECT: GL Name Sales.Cases] ELSE IF 'Sales Trend V4'.'2020A' = Gross Sales.'2020A' THEN 'Sales Trend V4'.'2020A'[SELECT: GL Name…
-
Looking up a module populated with same numbers
Hi I'm trying to lookup data in the format below. My LOOKUP formula is working but the issue is its only picking up the first record (Product P1). P2 and P3 are ignored as the numbers are the same. While this is counterintuitive, I need to work with data like this as the duplications could be either genuine or in error but…
-
Medical Expenses Level 1
Can some tell me why I get 0 for the medical expenses? It doesn't give me an error message but just shows zero. I posted screenshots I used this formula: IF Employed? THEN 'EMP03 Employee Drivers By Role'.Medical Benefits[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
-
Renaming the line item - Best Practices
Hello all, I need to rename a line item in a large model, I am wondering what are the best practices to do this? What should I consider before renaming to avoid destroying the model? Thank you in advance for your help!
-
hierarchy list and child list
hi! When I check list items in the parent hierarchy, I want to create a mechanism to check all items in the child hierarchy. What i should do? Please help me.