-
Gantt Chart Ability to Edit Columns
Hello, I would like to edit what is returned in the columns above a gantt chart. Screenshot below is what I currently see. I would like to remove/hide the year 2022 all together, and instead of showing months in the columns, show the numbers 1 through 12. And if that isn't possible, would like to remove the columns all…
-
PREVIOUSITEM() formula which is like PREVIOUS() but references a list item instead of time
Hi Anaplan, I was searching for the use of the PREVIOUS function but on a list item but it is not currently possible. @peter_mcanena has suggested this but only in a discussion thread. So as his idea suggests: PREVIOUSITEM(x, y) where * x: Any expression * y: List The expression x must be based on the list y.…
-
Do you feel it will be good to have Supply Chain related functions ?
Since Supply chain use cases are picking up, do you feel it will be good to have supply chain specific functions in Anaplan. If yes, then kindly promote the new idea I posted.
-
How do I select a prior list item without getting a circular reference
I am trying to build a model that looks like the above screen shot. Tier 1 - Tier 5 are list items and everything in the top row are list items. I am having trouble getting any ending balance to work (for reference, I'm able to begin the tier 2 starting balance and so on and so forth to pull the ending balance from the…
-
CONCATENATE Formula in anaplan
Hi experts, How to write "concatenate formula" in anaplan. We have 3 proprties in Customer list. I want to concatenate first and second properties into 3rd property. The format of the properties is "Text". Can you please suggest me. Regards, Uma
-
Date Import not working
Hi All, Need some quick help I want to import a date from 1 module to another module using Import action, however I'm error as "Invalid date" Module 1 - 1 line item (date1) | date format> currentperiodstart() Module 2 - 1 line item (date 2) | date format Now, when I'm trying to import date from module 1 into module 2, I'm…
-
Interpolation
How can we do interpolation in Anaplan? I need to interpolate scores from the following criterias: a. Min number with equivalent score b. Max number with equivalent score Thank you!
-
Performance Comparison - OFFSET/LAG/PREVIOUS/LOOKUP
Hi all, Was looking to get some input on a calculation scenario as community pages were a bit vague (or I'm using the wrong keywords). Now, I'm sure most of us understand how Anaplan thrives on being multi-threaded where possible, but when it comes to performing time-based calculations, there's a variety of ways to do the…
-
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
-
How to get Range of Values between two Booleans that are time formatted?
When the user select Two Boolean Check the range is defined so I want to get the range of values respective months.
-
Summary Calculations With the User List
Even though the Users list does not have a top member assigned to it, with the release on April 24, 2021, model builders will be able to use the following summary functions with the Users List: SUM, LOOKUP, ISFIRSTOCCURRENCE, CUMULATE, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK. Lookup First, let’s look…
-
Remove 10 million item limit from the ISFIRSTOCCURRENCE function
Brief description of the idea Remove 10 million item limit from the ISFIRSTOCCURRENCE function Expected benefit/impact Removing this limit would allow imports to be ran into large hierarchies that are referenced in ISFIRSTOCCURRENCE formula. Currently they fail with an error message.
-
How to select only one Boolean line item at a time by disabling all other Boolean options?
I want the user to select only one boolean line item at a time. When the user selects one boolean, other booleans should not be selected, and once the user unchecks the selected boolean, all booleans should be available for selection.
-
Black Box Timesum Drilldown
One of the best things about anaplan is the ability to drill through the model to see where values come from. sadly, anaplan is now quite limited in how you aggregate over time. at some point changes were made that more else require you to use the timesum function to aggregate over time specifically (SUM: does not work).…
-
Eliminating Sparsity
Summary: Sparse cells within an Anaplan model are cells that do not contain and are not expected to contain data. The platform still needs to allocate memory space to these cells even though they are not used. The trick is being able to identify and combat these cells in existing models as well as preventing them when…
-
how to pull values from one module to another module with no common dimension?
I have two modules A & B where I want to use values of one line item of module A to be a part of a calculation in module B. Module A and B have no common dimensions in between them. Please help.
-
Need to figure out the formula in anaplan similar to excel
Formula for Final exploration drilling (Dryhole) in excel is - Basically IF the first line items current year value is <>0 then then sum all the previous year and if the sum of all the previous year is zero then bring the data from other module. Question is - How to look up all the previous year?? for example if the year…
-
Export Action
Hi Members, Can someone please guide me, how can I create an export action? As Export Action is not displaying.
-
Supply Chain Related Functions
Just like we have functions for Financial (COUPDAYBS, COUPDAYSNC, etc) and Call Center Planning (AGENTS,ANSWERTIME, ARRIVALRATE) can we have something similar to support Supply Chain Planning? Like End of Stock, Beginning Inventory, etc based on input parameters?
-
Summary Method for Lookup function
Hi, What is the best workaround when using the Lookup Function and you need a Formula Summary Method? Currently, Anaplan does not allow this and for some cases, especially using % accounts, it is best to use the Formula aggregation in order to get the right math at top level hierarchies and Time Summaries (i.e, All…
-
Prior Year YTD total option for Time Ranges
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 date versus current year to date its a lot more fiddly. Alot of our monthly reporting is done through the Excel Add in and…
-
Time dimension formula
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 year, for example for FY23, Want to bring FY23 rates to all the months in target module. What formula would i use in terms…
-
Assign values to duplicate items
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 below UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan 5 A1 25-Jan 6 B1 25-Jan I want to…
-
Rolling NPV with timescale workaround
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, a relatively common requirement in investment analysis is to generate a rolling NPV — in other words, to calculate the NPV…
-
L2S3 Activity 3.3.12 Sys01 time settings by week module
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 Time settings by month'.planning period filter)
-
Level 3 Model Building: Schema Design - Part 2
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
-
NPV with rolling start date
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 would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from…
-
Average of active months
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 when in existence. In my module there is a line item for product status and this can be active, liquidating, terminated but…
-
getting the error: "Dimension of mapping used for lookup doesn't match any dimension of the result"
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- "Dimension of mapping used for lookup doesn't match any dimension of the result" . My Formula- 'REV04 Price Growth…
-
Splitting out a text field using a delimiter
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. (Similar to the way it works in a Text to columns formula) We have had a change in our HR system, and for our Egypt staff their…