-
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…
-
Ratio Summary - Line item & time.
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 Time. Any suggestions, can we have different summaries by any work around. Thanks, Manjunath
-
MROUND showing inconsistent results
Hi, I am trying to use MROUND formula to round to the nearest 100. However, there is some inconsistency that I spotted. original number * multiplier = number to round Example 1: Example 2: Why are the output number different when the "number to round" is the same? I want it to round to the nearest 100. If there number is…
-
10.2.1 Activity: Add Non Employee Expenses Module
I'm currently trying to add the formula for the Total row, and I'm wondering why the SUM and LOOKUP formulas I've tried are invalid or not working. Here are the formulas I've plugged in so far: 'OTH01 Non Employee Expenses'.Total[SUM:'OTH01 Non Employee Expenses'.Shipping Costs, SUM:'OTH01 Non Employee Expenses'.Rent,…
-
How to create a loop formula
Hi everyone, I am stuck on a formula. I have demands for 2021 and I need to calculate the demand forecast until 2030 by using the formula below Demand 2022= Demand 2021*Growth rate 2022 Demand 2023= Demand 2022*Growth rate 2023 . . . So how can I do that? Thank you!
-
Converting a list to another list
Hi everyone, I recently discovered something within Anaplan that has made my life a lot easier when uploading data. For reference, I work at a mid-size firm and we have data that comes from our accounting software, and data that comes from our enterprise reporting software. Sometimes the naming conventions of things are…
-
Two Ratio summary - Different for Line items and Time.
Hi Team, Can we have to different Ratio summary for both line items and time. it will be helpful in few scenarios where we have to calculate ratios have to be calculated differently for line items and time. Thanks, Manjunath
-
Quarter Apportionment
Hi Team, I have couple of queries regarding the below snapshot * Both Q1 & Q2 has 91 days, however the quarter balance is different? Can anyone explain the difference? * Are we calculating values for quarters first, & then segregating the quarterly values into monthly or is the other way around? * What does "Quarter…
-
How to calculate based upon a range?
Hi Team, Can anyone please help here to make the Commission calculated based upon the range defined in 1 system module? Second last column in 2nd module (besides commission) to be referred in above defined module.. and whichever range the % is falling.. that commission% must be referred in the below module.. Much…
-
Formula to end time
Hi I have this formula that will add 1(digit) to the months following the current start month however I would like it to stop adding number after month 23. I can't figure out how to end the argument/formula so it stops adding number. Ex: Current month is 0, Next month is 1, following month is 2 etc, last month should be…
-
Quarter calculation
Hi Team, Can anyone explain me this calculation? This calculation amounts to 102% instead of 100% As per my understanding, it should be 31/90 = 34% 28/90 = 21% 31/90 = 34% Still, I'm short by 1%. Can anyone explain Also, can anyone confirm what is "Quarter Apportionment"? Is it no. of days by each quarter? 2022 Even as per…
-
How to calculate the total amount without using Select function
Hi All, I have created a module with two list (Company list: A,B,C) and Fruit list (Apple, Orange, Pineapple) Let say company A and C are tier 1 and company B is tier 2 And then i have created another module without any list dimension but just only a line item, how can i calculate the total amount of Apple selling by tier…
-
Level 1 Activity 6 - No Medical Costs
Hi All, Desperately need help here! Why only the one field is not returning the results? EMP02 - Formula & Results In my REP04 File Results and Formula
-
New Formula Idea : Convert boolean into a number and stop IF BOOLEAN THEN X ELSE XX
Hello community, I have to do a lot of controls (boolean) and base and theses controls give me a value based on its true or not. I do a lot of these technicals line items for : -Controlling element -Color Coding -... I code it in 3 steps : * 1) Business Element (Number) : Uselly a business value * 2) Control (Boolean) :…