-
circular reference issue
hi, I am facing the below circular reference issue. what can i do to calculate "carried interest"?
-
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…
-
Grid & Row Formatting
Hi, I'm trying to format a module to make it more user friendly and am running into a few issues (see below). 1) I'd like to have an alternating row background, but for some reason I can't update the module grid settings. In Anapedia, it says the following: Change an individual grid style The default style for a grid on a…
-
Include Categories as part of in model Pages Menu
Apologies if this has already been posted but I was wondering if it would be possible to include categories (and perhaps an option to filter by these) in the Pages tab of the model development environment. At present it is only possible to sort by name, this may be confusing if categories are used to identify stage of…
-
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…
-
Duplicate entries - Module to module import
Hi, While carrying out a module to module import, if we do not import zeroes first in the target module, the values tend to sometimes double up if we execute the action twice (even after selecting the "Clear target prior to import" option while creating the action) but sometimes they reflect correctly even after executing…
-
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
-
NUX Board optimization : Copy Formatting
Hello everyone, I am a Solution Architect and building applications and pages. I am aware of the functionnality "Save card as template". Nevertheless, I think we miss a functionnality here. In fact, the functionnality "Save card as template" give us the possibility to copy & paste a same card to another page but the…
-
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.
-
Show Precedent Line Items
Excel has a great feature that shows dependent and precedent cells for formulae. For those that do not know, here is a screenshot of trace precedents in action: The blue arrow is indicating that Profit is dependent on Costs and Revenue. This is a great visual way to show how cells affect one another. Whilst Anaplan…
-
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
-
Level 2 3.2.11.2 "Filter to show months only" - in a saved view
Hi all, I am working on Level 2 3.2.11.2 which is: And I am stuck on the last bullet point "Filter to show months only". My original SYS00 looks like this: And I made the saved view as per instruction like this: The final produce at stage 3.3.12 to look like this: Where the first grid to come from the saved view. I assumed…
-
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?
-
ALM Version Structure Settings - Allow for CURRENTVERSION setting updates in PROD model
Other structural version settings are now unique to the production environment and the Current Version setting should be allowed to be changed directly in the PROD environment as well. Currently if you are using the native version formula settings in order to calculate for specific versions, there is no dynamic way to…
-
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
-
Time Subsets
We would like the ability to create time subsets for more granular time ranges (days, weeks, months), that may not match the current model Time Scale of Years, Quarters, etc.
-
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..."?
-
What I can do to make sure I get accepted to the Anaplan Model Building Course?
Hi everyone, I have registered for the Anaplan Model Building Course. How long before they contact me and inform me if my application is accepted? I really want to get this course and am eager to learn about it. Is there anything I can do to make sure I get accepted? Thank you, everyone!
-
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!
-
2.4.7.1 Create Demand Forecast Grid UX saved view
Hello, I really need some help for this step. I completed to first conditional formatting rule set up for Final Forecast line, but I have no idea how to set up the for Initial demand Forecast. In case, I attached example from training and how I set up and result that came out. Please help me with this. Thank you