-
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.
-
1.4.5.2 Import from Saved View
hi, may i know how to import save view to P3 SKU? thanks in advance.
-
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?
-
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…
-
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
-
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.
-
CAN Property become list
can any let me know, can the property become subset of a list
-
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
-
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?
-
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
-
Formula Help (Condition Statement)
Hi, I need help on creating a condition where if one LI is lesser than another LI, then my intra-month growth amount must be less than my write off amount. Not sure how I can make this condition happen in Anaplan. Please advise. Thank you
-
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…
-
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…
-
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.
-
2.4.7 Activity: Create Saved Views for UX
I'm lost at conditional formatting to only show the highlighted items in the example. Is there another formula I should be using in a module or this same module? How do I get the conditional formatting box to allow me to select "SF Bay..."?
-
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…
-
Dimensions: Time (Year)
How to change the Time to years
-
nested Sum if
Hi, I need to get total of selected roles occurrence which can fall in three different categories. For example, among all the users , I need to count how many users have role of ADM, and then if they had the same role 3 months ago also- If yes it will be counted in No change list ( Category 1) and if their role is changed,…