Modeling

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).…

Hi, Is there a way in Anaplan to check if the list member has data in any module we have ? Thanks, Tom

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…

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??

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.

Drill downs in Anaplan Modules should have a feature for checking what each part of the formula written does. For example if there is a If condition with a nested loop with multiple formulas and conditions in it, then there should be a provision to select what each condition does regardless of the condition being True or…

As we put headings as empty modules, these then appear on the model map. Could we not include zero cell modules on the model map, or give the builder the ability to exclude.

Hey Team, I am facing this issue on MAILTO. I tried getting it in two ways: - Option 1: - Used MAILTO functionality MAILTO(u, v, w, x, y, z) Result from triggering this option from the backend and frontend (NEW UX) has led to an error where the line breaker (%0A%0A) inserted in the body of the mail does not function.…

Hello Modeler's I would like suggest one enhancement or feature, this is the thing I feel like anaplan should have search option. As we know most of us not like to scroll a lot for what we need. I found this while doing import action from anaplan with connect to anaplan models.There will be a lot of saved views we have and…

Hi Guys, I am unable to load data in Volumes. The issue is that file is loading sum of all the columns into single month. e.g. in Jan'19, data for Jan'19 from file should load, but it is first summing up data from Jan'19 till Dec'21 and then adding that number in Jan'19. Same process repeats for all months. Can you please…

I have been trying to figure out how to solve this issue that keeps popping up when I enter this formula: IF Employed? THEN 'EMP03 Employee Drivers By Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 I know it is something with the Roles list and the…

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…

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…

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.

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.

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…

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…

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!

hi! I would like to know how to calculate the remainder of a division. Example: 5/2 → 1 , 45/7 → 3 Thank you！

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

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,…

We need a function which can give us timestamp on last data entry for a specific cell. This will help us to compare that time stamp with our custom date in some specific use cases. example: Todays Date: Line item to capture today's date via daily data refresh Order Date : User entry Line Item Time(Day) formatted Ordered…

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…

Hi, I have created dependent drop down list line item. . See below example data entered by user. Rack Market City is based on Rack market State. Market -StateRack Market - CityAlabamaBirmingham, ALAlabamaBirmingham, AL Later user changed state value to California and forgot to change the related city. But city is still…

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,

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…

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…

Hello! I have found very gentle and beautiful solutions for filtering lists if they are composite ones, but i am struggling to build a filter for a-non composite list which has 5 levels of detalization. Hierarchy looks like this: And in Anaplan it looks like this (client does not want a composite list, he wants it in this…

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

 From 1 line to several, so that a same dashboard can have several use cases (compact table to work on, then small/medium/large images to have a recap to browse).