Hi, I am looking to set the first cell in my time range as an input and the following time periods to be based on the first cell. I think I use the offset function for future years but I'm not sure wh…
Need to update the formula in EMP02 with EMP03's info. But I keep getting an error and I have no idea where I have gone wrong... Can anyone point me at the right direction? This is the formula I used.…
Currently you can compare time periods using operators '=', '>' and '<' which is great and very useful. But when it comes to comparing more than two dates, it becomes a nightmare to find a MAX or MIN.…
Hello Everyone. I am Using SPREAD Function on Monthly Time range. I want to Spread value of only one Single Column. i have used boolean and if else condition for that but not getting it. Spread Functi…
Hi, I currently have a Debt Reporting module in Anaplan which is built on the list P6 Bank Loans. How it flows is P3 Products > P4 Fund Entities > P6 Bank Loans. So within certain products, there may …
currently working on the level one exam and stuck on question 6 with rev04 model getting the formulas in. i know the formulas are right but the error pops up. so is there another step before entering …
Hi, Can anyone tell me why Anaplan has named their new calculation engine as "Polaris". Is there any kind of significance to the name "Polaris"? Thanks BB
Hi everybody, wondered if anyone could help me on this as i've been stuck for some time. basically we are supposed to have our grid view look like attachment 1, however, mine looks like attachment 2 &…
Hi all, I'm trying to set up a project planning model in Anaplan. As part of this setup, I'm trying to calculate the start date and end dates based on the dependencies. The logic I'm trying to build i…
Hello, I am trying to import data into list by creating an saved view in a module. That module has a line item of subsidiary view. That line item is not getting mapped to list subset. Explanation: I h…
Friends, need your input and help in meeting the below scenario where I have a module n Dimension (IDs) and few listtype line items. There are repeated values if I concatenated line items (fyi in Anap…
Hi All, Is there any function in Anaplan, which can be used to get the next cell value from first line item in a new line item. or 2nd scenario is to ignore the prior cell values, For example: IF SL1(…
Hi everyone, I am currently trying to develop a model that references two different regions within a list (that is production data). Let's say we have 2 line items: New England Revenue Total Company R…
Hi all! In our model we do not get the wished results from a moving sum. I want to preform a movingsum over a line item which is constructed with an if statement in a model with versions. This is my l…
My formula for Ending Inventory = Beginning Inventory - Forecast Demand + Confirmed Purchase Order Receipt On the SKU level the ending inventory values are matching with the values shown in the activi…
Hi I want to Textlist function. I want to get Customers by Product List. But I don't know how to use it. ListLineitemProductCustomerConbinationTextListP1C1☑C1,C2 C2☑C1,C2 C3 P2C1☑C1,C3 C2 C3☑ Do you h…
Hi, In response to question 7: What was the total expense for the FY21 executive bonuses in the Americas? the total equals XX.999999999996 do I have to round up? Thank you
Hello Could you help me with the following case please. I have a formula that is using SELECT but in addition to that I need to add a sum controlled by months with some members that I have already cre…
When model building often we get requirements that require changing the dimensions of a line item / changing hierarchy levels etc. Basically things that will break existing formulas. To make these cha…
Hi, I have a requirement to pull the dates in the module, the source and the target has different dimensions. Target module Source module I want the dates basis on the revolver in the target since I c…
Hi, Can you help me with the next item. I need get the total value of the line item "%" and put in the line item "Pond". in the line item "Pond" is using a LOOKUP but a cant see any value.
Hi , I want just calculate the moving average for the last two months, however once use the following formula IF ISACTUALVERSION() THEN Revenue actual ELSE movingsum(Average Revenue,-2,0, AVERAGE) The…
I would like to see shorter time periods that we could control for example rolling 90 days, 16 weeks etc. Realizing there would need to be some sort of trigger of control set a start point. A potentia…
Hi guys, As you see in capture 1 we have the Role wise salary details , but i a not able to get these salaries by employee wise , please look capture 3 sys module is there anything i am missing to get…
Hello Community, anybody to help me, I'm trying to pull data from Module which has Time,Version,Lis as List and Amount as line item in Target module which does not have time and version means it has (…
Hi there, While creating the saved view for the line chart for my DEM03 Demand Forecast module i noticed that I only have 1 year of data for FY20. The requirement is asking for a view with 2 years of …
hey guys Please let me know is there any function for Transfer the value from one time period to another time period Without using offset,post,lag need to transfer the values directly
Hi, I have trying to complete the Medical costs for 2 days now and I can figure it out. I created the list of roles: Created EMP003 Employees-imported employees by roles data Added Roles to SYS08 then…
Hello, I have a formula written that takes "Company Churn" / "Previous Revenue" Previous revenue = PREVIOUS(Revenue) The formula works for the individual months, but when it does the summary the rates…
Hello Team, I was wondering that can we have different ratio for line items and time. For ratio as summary in Anaplan we have only one option, which will calculate the same for both line items and Tim…
