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 woul…
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 …
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 environ…
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 mo…
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 upcomi…
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 els…
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…
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, t…
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:…
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.
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 Profi…
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 formu…
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…
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. C…
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 yo…
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 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…
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 overri…
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.
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 formattin…
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 lear…
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 ye…
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 …
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…
