Hi, We have a large reporting requirement for reporting versus prior year for reporting month and Year to date. The month is easily achievable but if we want to create views that compare Prior year to…
Source Module has Year, Target module has Months. Source - Time dimension (YEAR), Cost center dimension, Line Item Target - Time dimension (Months), Cost Center dimension, Line item Source has rate by…
Hi I have below module that is update every few days UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan two records were updated when the next time(eff from) the job runs like …
Author: Iain Briggs is a Certified Master Anaplanner and Associate Director at Lionpoint Group. One known limitation of Anaplan’s NPV function is that it calculates across the full timescale. However,…
May I know if I have this correct: Line Item Planning Period Filter: the formula is 'Sys00 Time settings by month'.planning period filter Line Item Planning period Filter weeks only: monthvalue('Sys00…
Hi Team, Plz help me with the formula for Define in Active Subset? line item from chapter (4.2) List Subsets - Advanced Topics As I am unable to add subset in to the formula. @jared @Misbah
Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module. So in Jan-24 it wo…
Hi, I have a module which shows asset values on a quarterly basis. For terminated products, the current asset values are nil. However, instead of showing nil, I want to show the average asset value wh…
I am doing level 1 model building(Activity-9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module) When i try to enter the formula for the lineitem 'Unit Price %' i get the following error-…
Hi Everyone. Just wondering if anyone had managed to find a way to split a text field out to show all characters to the left or right of a delimiter, rather than a specific number of characters. (Simi…
Hi We have a requirment as below. We are setting up a General List to track the consumption of hardwares at different sites in the world. There are two columns in this general list. One is Combination…
Hi All, I am working on one use case where need to calculated the value on the basis of previous list item. Module doesn't have a time dimension. But I've created mapping module to identify the previo…
Hello everyone, Want to the mapping criteria you could use, the time source data does not have the same dimensions as with the target the result by using LOOKUP function. Thanks,
Hi there, Current limitations with the version dimension mean we are not able to select Version as a list formatted line item (there is a separate ticket with community support on this topic). Because…
Hi, Fellow Anaplanners, Could anyone provide guidance on how to configure two distinct charts so that they share the same scale on their y-axes? This is necessary for ensuring a consistent and accurat…
Hi, I'm trying to create a formula that will pick up the first day when the LI 'Y02 Accounts (Forecast)'.'Closing Balance (01)' is less than 1 million in the forecasting days. The formula below is wha…
Hi All, I currently have a module with 2 lists with data that need to be in another P&L list via 2 mapping tables using a methodology. Source Data dimensions: List 1, List 2, Time: Month Target P&L di…
Hi presently I’m in the process of building a hybrid waterfall calculation model —- where I need to show both portfolio company information as well as Investor level carry calculations. I build module…
Hello, I am trying to do a workaround where I am not able to directly map a Parent and Child relationship but the users would want to be able to alert owners of a subsidiary account living in a differ…
Hi, I have a question, I have encountered in some of our models, where we want to limit a value to be 0 if it is negative. The way we have done this so far is by making an if statement so: if A > 0 th…
Hello Everyone I have a logical question to make sure my approach and formula is correct for demand forecast in question on the LEVEL 2 SPRINT 2 activity . As we see, we have to create the baseline fo…
I have an issue where I am creating a fillable form for a client that includes entering a start and end date. So the user would chose a client and then a product, enter start and end dates and I need …
Monte Carlo method is an algorithmic technique used to understand the impact of the variability of a set of drivers in a forecasting model, using a probabilistic approach. It is widely used in environ…
Hello, i am trying to find a solution to the following user story: There are a set of modules for a reporting page that currently consist of multiple dimensions (we cannot use a combined list of only …
Would like to be able to use wildcard characters in anaplan formulas, specifically in the SELECT function. Ie. I have this: IF Version Selection.Selection[SELECT: VERSIONS.'2018 Actuals'] THEN "SBUDGE…
Context: * We have an ICM (Incentive Compensation Management) model with a DAT03 module that is an upload (from our data hub > SQL query) of all the monthly transactions we need to pay IC on. It inclu…
Hi Anaplanners, Does anyone know how to build the calculation modules that would assign the business rules to the transaction details? My current method involves me building a boolean module to fetch …
Hi, I'm trying to create a logic into the line item "End". My goal is to count the number of times a specific month appears without including the first occurrence. If November appears 4 times, I would…
Hi Community, To give the backstory of this - I have a module, where I first import one data file into, with Loan-Hedge ID List) and line items as the dimensions. The second file I import is a similar…
Description of enhancement required Ability to allow to aggregate using Boolean mapping. Currently mapping can only be applied over List elements. It would simplify many formulas if we could simply SU…
