-
I want some help in using DCA - Dynamic Cell access
Hi, Below we have 3 line items in a same module, I want to apply DCA in such a way, If I select Country, Sub-region and Region should disable If I select Sub-region, and Country and Region should disable If I select Region and Sub-region and Country should disable. Can you help me in writing the formule for Read and Wirite…
-
Performing Matrix Calculations in Anaplan
Hey, there I'm new to Anaplan and I'm exploring how to smoothly execute a matrix product within it. I have two modules: one resembling a (1,5) matrix and the other a (5,5) matrix. My goal is to perform a matrix product of the form (1,5) * (5,5) * (5,1) to derive a single number. Can this be done directly in Anaplan? If…
-
OEG Best Practice: Performance issues with CUMULATE over lists
Problem statement When using CUMULATE over a list—this is when using the format CUMULATE (x, y, z)—the performance can be poor with anything that exceeds a few million cells. This is because the function is running on a single CPU thread, which differs from nearly all Anaplan functions. Anaplan gets its efficiency from…
-
Replace a nested If that has many if's
So i have a nested if statement that checks the status of a shipment. "cancelled" or "storage" first using boolean, the progresses through a series of dates to see which have been added, finally defaulting to "At Origin" if it has not left yet. Multiple IF's are not ideal, but I can't see how I get round this one. Even if…
-
Level 2 Sprint 3 Exam
I have tried to take this exam. There are two formula questions where I provide answers that work based on the information provided. However, the system will not accept these formulas as valid answers. (Questions 3 and 9) How do I either have these formulas accepted as value or understand why they are rejected.
-
Alias Names for Time, Versions, Modules, Line Items and Dashboards
Hi Anaplan, It would be great for Anaplan to allow users to create alias names for: time, versions, modules, dashboard, list and lineitems. Thanks, Usman
-
Alternate Solution for RANKCUMULATE Function
Hi All, I have a solution using the Rankcumulate function but I want so avoid using it due to the performance issues. So I would like to know if there can be an alternante solution using other function Logic : First I'm ranking the Sales data Weighted distribution is calculated for ex: 95/3220 = 3% Cumulate distribution is…
-
Level 3 Commission Forecast
I'm currently struggling with the calculation of the monthly commissions FC. Issue: Quarterly commission Forecast: Unable to get quarter values by sales rep. How to bring down Annual sales target into Quarterly? Kindly help me on this.
-
Create a Formula to Reference a User's Model Role
Dynamic cell access can be extremely challenging with long user lists, especially if you want a user's read/write abilities to be dependent on their model role. If we were able to reference a user's model role via a formula, we could create role specific criteria for dynamic cell access.
-
Formula Question
Hi, I'm trying to create a formula that will pull values in accordance to each weekday. Below is the Formula I'm currently using. I have screen shots of the Modules I'm pulling from as well. If you need more information on the topic please let me know. 'D01 Funding Ratios'.Average of Fund * '01S03 Weekday count by…
-
Summing a percentage of a list amount from one module to another
Here is my situation: I have a module that contains a $ amount for a list of accounts , I am then mapping those $ amounts to another module that contains line items that I have in a List. In my screenshot you can see in Line item Mapto contains values of the list as well as Line Item Mapto2 contains values of the same…
-
selective access via formula's in module
Hi all, It would be helpful if we could control selective access via a sort of system module with booleans. This would allow a relatively standard import to update access that can be done by regular users if set up by the admin As well as enable some extended filtering capabilities and references per user to be made. all…
-
Copy paste formula from excel into Anaplan blueprint
Hi Anaplan community, I wanted to make a quick fix to existing formula in my Anaplan blueprint view, so I exported my blueprint view to Excel, used the find&replace functionality in excel to update all my formula at once, and then I wanted to paste back my formula in Anaplan blueprint view, but it gives me this error…
-
How does one safeguard against losing data with changing current fiscal years
I would like to use the out of the box TIME dimension/logic. However, I do have concerns about losing data if a fellow model builder inadvertenly changes the current fiscal year. How have others handled this situation? We have considered building exports to backup these modules every night and store the data outside of…
-
using the cumulate function
Hi all, I am trying to use the CUMULATE function to cumulate actuals (number formatted line item) over a subset of periods 'SS Periods Current year' (a subset of custom list, not Anaplan time). I first thought that I could not cumulate because I was using a subset, but even replacing the subset with the full list did not…
-
Usage of First Occurrence formula with conditionals
Hello, I'm using the ISFIRSTOCCURRENCE formula to assist in creating hierarchies so the processes don't return a bunch of errors when generating the hierarchy, but now I'm facing a little issue, I want the first occurrence formula to return true only if other columns match some condition, but I can't find the correct…
-
Tell us what your teammates need from your dashboards
As an Anaplan user tasked with helping your teams better understand their data through your Anaplan UX dashboards, we want to hear more about what your end users tell you. What kinds of visualizations are they are asking you for, what do they struggle with in accessing and understanding your data, and how you resolve those…
-
Add XOR formula
Title says it all, a XOR formula would be really helpful and reduce formula length when trying to test an exclusive or. For those unfamiliar, here is the logic table for XOR. It acts as an OR however if both inputs are TRUE, then XOR returns false.
-
Using LOOKUP and SUM with Formula summary method
A detailed description of the enhancement that is being requested. We would like to request an enhancement that would allow to use LOOKUP and SUM with Formula summary method. Currently Anaplan doesn’t allow to do so, although in many cases it is needed and doesn’t break the math. If available, could you please provide a…
-
Function for Contribution
There is no simple way to calculate contributions all children levels to the highest parent level - for product levels, time levels and location levels. The lowest level should be considered the value to express as a contribution of a level you need to select. Examples: Week 1 to 4 belongs to Month 1, which belongs to Year…
-
Level 2 Sprint 3 INV01 Inventory ordering Boolean line items
Hello guys, I've noticed that my Boolean line items have stopped functioning somehow. It was okay when I first created them and stopped working when I added DCA. I checked the formulas and write accesses but they seem fine.... Any ideas?
-
Date Line Item using Min Summary
Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO
-
End date that should be a working day only
We want to get the End date but it should only fall on the weekday, we have tried other workarounds but it didn't work as intended. See screenshots fyr. END DATE (working days only) = START DATE + Duration Days we also have a module to count the weekends and holidays so to get the END DATE (working days only) END DATE…
-
Round Function
It would be great when using the Number of Decimal Places in the Round function if Anaplan rounded to the number of decimal places asked and it stayed rounded when going up the hierarchy. The summary is set to "SUM". For example, I have five children members with a formula ROUND(Value $ * value %, 2) function. Each of the…
-
Conditional Import
I have two columns, Column A and Column B. Column A is a manual input and column B is populated by an import action of the data of Column A. I have created a sperate module with Boolean checks to make the data of Column B not editable using write access driver. However when I run the action to populate column B new list…
-
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