-
How to have first cell in a time period as an input and subsequent time periods as formula
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 what to do for the input. Appreciate any help with this. Tom
-
Level 1 Exam - Question 5
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... IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP:…
-
MAX() and MIN () functions over time periods
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. Unlike with number or dates, you either have to go through countless IF THEN ELSE cases which is probably impractical or…
-
SPREAD Function
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 Function is adjusting All column values. and I want to spread value of only one column.
-
Suggestions on how to re-model a module
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 be several bank loans under the same facility. What would be the best way to report under Facility, rather than Bank Loans?…
-
Data mismatch error
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 the formula that i should be doing to bypass this error?
-
Polaris Calculation Engine
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
-
L1M1 12.4.6 Activity: grid view (2nd part of task)
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 &3, i've double checked the formulas, don't have a filter on,etc and cannot figure out why the numbers don't match, as they…
-
Setting production lists
*Content reviewed for accuracy June 2020 Making sure that production data lists are correctly marked within a model is a key step to setting up and using Application Lifecycle Management (ALM). This guide will provide a solution to how someone can make revisions to their model to allow for the tagging of a list as a…
-
Break Circular Reference
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 is as below, Start Date = IF ISBLANK(Dependent Step) THEN Project Start Date + Lead Time ELSE End Date(LOOKUP: Dependent…
-
Importing into list from subsidiary view
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 have 3 lists L1, L2, L3 (all are hierarchy lists) One list created for requirement to use it as dependent drop down - LD I…
-
How to identify duplicate text in lineitem to buila a unique list?
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 Anaplan; NAME(A) + NAME(B) + NAME (C) + NAME(D)) and need a unique list from those concatenated values. Tried RANK but can't use…
-
NEXT or Previous cell values without Time dimension
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(List item) ignore first 1 cell, for SL2 ignore first 2 cells,SL3 ignore first 3 cells ....and so on. I have done this using…
-
Department as a % of Total Revenue
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 Revenue I want a ratio where I can reference our P&L (300ish line items) and say P&L Revenue [Select: List.New England] / P&L…
-
Movingsum over if statement based on isactualversion()
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 line item if statement: Where isactualversion is iscactualversion() and is thus dependent on the version. Then we have a line…
-
Ending Inventory
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 activity picture, but when i change it to all products then the values are not matching up. Please help.
-
About textlist Formula
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 have any idea?
-
Level 1 Exam question 7 (should the answer be rounded?)
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
-
Can I use the TimeSum with SELECT
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 created but when using the timesum it generates an error because it conflicts with the SELECT. How could I solve it? The…
-
Allow for 'Invalid' formulas during model changes
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 changes to an existing model I'll laboriously go about copying formulas that will break somewhere else, carefully making a note…
-
Get dates in different dimensions module
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 can't use sum function on the dates to pull it any workaround for this use case.
-
Get a total value on other line item
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.
-
Get Average of two month on same line item when is Budget
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) Then circular reference error shows up. Could guys give me hand on how can solve these issues? I am looking forward to your…
-
Time Subsets
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 potential user story I need to be able to solve is: I plan by month but need a 90 day outlook As part of that 90 day outlook I need…
-
Lookup by roles and employees & country
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 releation please help in that to get the employee wise details
-
SELECT AND LOOKUP
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 (Lis and amount as dimension) I'm trying to avoid hard coding {Source Li[SELECT:VERSIONS.ACTUAL,LOOKUP:GLOBAL DRIVE.FY]}.…
-
Level 2 Sprint 2 - 2.3.11.3 Create Line Chart Saved View
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 data (FY20 & FY21). I'm looking for some help in getting my formula correct. What i did was i created a new line item in my…
-
Transfer the value from one time period to another time period
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
-
Medical Costs-Cert Question
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 imported the txt: I try to amend the formula to take in EMP003 annd SYS08 Roles Medical costs - IF Employed? THEN 'EMP003…
-
Previous Function Cut-Off Date
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 are incorrect because it always has one month more worth of data in the revenue line item. Is there a way to say "If the…