-
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) :…
-
How to get the total amount without using Select Function
Hi All, I have created a module with a list 'Fruit" and a list with 3 list item "A, B and C" Afterward i have created the second module only include a line item and without and two list mentioned above. How can i get the amount of Apple in A without using the function of select? Since i would like to reduce the size of…
-
3.3.5.1 Create Inventory Ordering Module
Hi, may i know how to i import TRA01 to DAT02? Anything part which i may have miss out? not sure why my data is 0
-
Depreciation Straight Line method
I am Trying to calculate Depreciation by straight line method. But I don't know which function to use. It would be very nice if you me best method for calculation of the same. Thank you in Advance
-
Cumulate Function in numbered list
I am facing cumulate function issue for numbered list. If unique index number of numbered list are #1 and #3 , without #2 (deleted for some reason), cumulate function fails to cumulate for list item with unique index number #3. Please suggest any fix for this. Regards, Omkar
-
Pick Item name against item code
How to pick List Item against the List Code? have a situation..... explained below 1. I have a list which looks like the below 2. Using this dimension, there is a mapping module also. 3. Now, there is a set of Transactional data which consists of codes e.g. - <another list> etc. as shown below 4. Now, I am looking a way…
-
Anaplan Compare functionality Issue - Name of Compare to
Recently this changed so that when you use the native Compare functionality in Anaplan classic, it no longer shows the name of what you are comparing to, but shows as "undefined". Previously this would have shown the name - in the screen shot, instead of "undefined" it would have noted the name of the version I was…
-
How to populate number series in every upcoming month in a line item
Hi, I have identified the starting month to start the series through boolean and time period function. However, starting from that month till end i want to populate numbers in a series on every upcoming month(eg. if starting month is march then for march i need to populate 1 in a separate line item. now for April the value…
-
How to calculate distinct values ?
Hi All, I have a list which has Product as parent and SKU as list. I am trying to calculate the number of SKUs with demand > 0 for all periods. Right now, using this formula - If demand > 1 then 1 else 0. The issue with this formula is that the summary adds individual SKUs with demand at yearly level. See below screenshot…
-
what are the most common Challenges in anaplan & how can we deal with it
Hi guys, Anyone let me know, What are the most common challanges in anaplan while dealing with client & in support projects . How can we deal with it
-
How Define the current time period for system
Hi Guys, How to define the current time period for system with out using Current Period & Switch Over, isactualversion & Iscurrentversions. is there any possible way to get with formula. BY this formula, system should find the actual period and Forecast
-
CAN Property become list
can any let me know, can the property become subset of a list
-
Put total in a line item
Good afternoon, I would like to place the total value of line item '%' in line item 'A'. In other words, I would like the amount 17,259 to appear in all the fields, but I haven't been able to do it. Could you tell me the formula to achieve it?
-
combine two line items
I have two line items that are addressed to the same list but each one stores a value. that is, in lineitem1 there are some countries in lineitem2 there are countries that do not appear in lineitem1. I need to combine lineitem1 and lineitem 2 into lineitem3. How can this be done?
-
Number Formatting Precision / Stop dividing by 1000
I would like to propose a feature to instead of dividing by 1,000 to show items in thousands or 1,000,000 to show numbers in millions, that this is handled by the number formatting. This is a little used feature in excel where you can apply a format to a cell with the value $32,500 to display as $32.5. In this case the…
-
actual and forecast
Hi there, Anyone please help with the formula, Here i have actual value in one line item based on that the override line item should be editable. where jan22- apr-22 is actual values, show that override line item should be editable from may 22 Please suggest
-
No reference cell count
If Anaplan can provide the column for the total number of no reference cell count for each line item in module grid view, It will greatly help modelers to identify the line items which is having more sparse cells. Modelers can work on those line items to less the sparse cells. I believe it will help at the module level as…
-
Fake Time to Real Time Calculation
Dear All, I have one use case where I have created one template for input the data. For this I used fake time dimension because the data will enter at monthly level in Year 1 and for future it's on yearly. Screenshot one shows the template which used to enter. But I am stuck between creating summary report. Because for…
-
Multiplication and adding two different line items
Class 1 is starting from 7 mar and class 2 is from 21 mar Now i need to write formula in Total For example in 21 mar Column, 62 * 2 (which is week 3 * prod ) and 80 * 2 (which is Actual Start - Day 1 * Prod (Next Wave)) (62*2)+(80*2) = 284 ----- the formula in Total is not correct now I try averaging the Prod and Prod Next…
-
How to get a first value of line item
Hi, I have requirement where I need to identify the first value of Borrowing line item and that value would flow into initial commitment. So I have used ISFIRSTOCCURENCE with a logic IF Borrowing <> 0 THEN ISFIRSTOCCURRENCE(Borrowing, Revolver Facility) ELSE FALSE but this will giving me two occurrence. what I need is the…
-
I want to get the first month of a period set in module calender.
hi! I want to automatically display the first month of a calendar set in a module that has not been applied to. Can ido it？ Please help!
-
Actual vs Plan Reporting Issue (Different grains = double-counts)
Hi All, I have the following 3 Modules: Module 1 - Staging (Actuals) Lists - Supplier, Service Category, Time, Line Items (Amount) Module 2 - Input Plan Data Lists - Supplier, Service Category, Maintenance Category, Time, Line Items (Amount), Versions Module 3 - Reporting Module Lists - Supplier, Service Category,…