-
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…
-
Error with copying formula over
"Invalid formula for 'REP03 Profit & Loss Report'.Car Costs: Automatic sum of 'EMP02 Employee Expenses'.Car Costs over ---Subsets--- hierarchy is not possible as ---Subsets--- does not have a built-in top level" I keep getting this error when pasting a formula in from the learning center.
-
New to the Forum
Greetings everyone, I am new here. I am new to Anaplan as well. I completed Level 1 and Level 2 training in December and I am happy to report I am now working as an Anaplan Analyst. I do not have a data background I actually was an insurance adjuster for 15 years, so this is a different path for me. In all transparency ,…
-
Child with multiple parents
Trying to make a heirarchy where a child is having multiple parents Trying to fix it out .How do we suppose to import without getting any error
-
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…
-
reset times for minor issues are becoming a major pain i Anaplan
13 minutes because i used number instead of text as a format !! Surely this can be prevented, it makes developing a very slow process and stops a very busy office from working. Are we supposed to develop out of hours????
-
Dependent Pick List for Line Item Subset
Hi, I'm trying to set up a dependent pick list for one of my line items. I have set up the combo list with properties. The pick list is a line item subset. I'm not getting the option to create a dependency for my pick list despite seemingly setting is up correctly. Are LIS pick lists not able to be dependent?
-
How Do I View if a Line Item Has Been Used as a Filter?
Hello, I am doing some model clean up from a previous development team, and am trying to remove extraneous line items from the Anaplan model. Is there a way to view if a line item is currently being used to filter a dashboard, or module somewhere in the model? If not, that might be a neat enhancement, similar to the…
-
Look Up Not Working
Hi Community, I have a source module with dimensions of P2 (P1 is the parent of P2), In the target I have a dimensions of D1. I have one to one mapping done from D1 to P1 in a separate line item with dimensions as D1 and formatting as P1. When I use lookup formulae the data is not coming to target module. Any reason why…
-
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…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
hi i have seen a few solution, however, i am still not able to go get. May i know how do i reslove this error? thanks in advance
-
1.4.5.2 Import from Saved View
hi, may i know how to import save view to P3 SKU? thanks in advance.
-
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…
-
Location Planning (as a part of SWP)
Hello All, I was interested in learning about location and Strategic Workforce Planning in Anaplan. I am currently in the FP&A space. Wondering if there are any literature, videos, or even learning models within Anaplan that I can have a look at.
-
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
-
Total of specific nodes having selective access enabled
Hi Team, I needed help on how to get a total of selected cost centre from a List for which a user is having access to (only specific nodes) sub total is required to be viewed on a report. For example: In screenshot below: User wants to view a subtotal of specific cost centers(for which they have access) in Reporting…
-
8.5.3 Activity: Import Data into Volume Inputs Module
I am trying to upload Data into Volumes model . Please help me
-
Override and Edit
I want the Override Sales Target line item to be editable for input when Override boolean Line Item is checked (i.e. true) for the same row otherwise it should be all 0.
-
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?
-
6.11.2
I am having a problem with inserting the formula. In level 1 lesson 6.11.2 You have to put formulas in for actual, budget, and forecast. the formula for actual and forecast worked fine. but when I put in the code for the budget it does not work. See photo
-
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