Hi, Current setup: I have a source module where I will get actuals percents every month. The module doesn't include the version dimension/list. Target module: I want a module that includes version act…
Hello, I created a matrix, including two lists (tasks list and the built in users list) as dimensions and a boolean formatted line item in order to set write access for an other line item through the …
Hi Community I have a module with the following structure: Module Name ---INPUT--- Transportation fee INPUT Meal fee INPUT --- CALCULATION --- Trip expenses CALCULATION What I want to create a column …
Hi Community, I am struggling building up a Variance dashboard at CC/GL level. Having so many members I encounter spacing issues. I have also added a numerous other dimensions (Rows - GL accounts / Co…
Hello, Does anyone know of a quick formula combination that evaluates the line item values for list members that share a parent? In my example provided the puppies have the same parent. They each hav…
Hi, I need to covert the text field range to a period number, what should be the formula for that? I am getting the text range input as: JAN 2019 - DEC 2019 (in a single text cell) I need an output as…
Currently the Round Formula can be applied only on specific lines or calculations. Would be nice to have an option to set Number Rounding at 'Number settings' apart from Number Format Display.
I ran into the issue when I needed to pull the data from the module with a timescale as a one of dimensions to another module that also contains timescale as dimension. I used time formatted line item…
Hi All, I am working on a model where in a dashboard I have to reduce the time range of a drop down from 10 years to 2 years. It displays 10 years as it uses the original time period of the anaplan mo…
Hello, I have a numeric line item (picture attached) with cells filling in as 1 if they fulfill a condition, 0 if not. The total number of 1s in this example is 1514; I need to reference this total in…
Hi Each individual country enters data in their local currencies. However, for the reporting in USD, it is to be done at Region level only. There is no need for Country level. Right now, I managed to …
Hi, I have a line item formatted as date in the module like: "4/29/2020" and i want it to convert into "As of Apr 29, 2020". I tried myself with the below formula but didn't work, kindly advise: "As o…
My bad, idea already exist...multiple times (not sure how to delete the post) https://community.anaplan.com/t5/Idea-Exchange/Add-Bulk-Copy-to-action-list-to-be-added-in-process-chain/idi-p/40525 https…
Hi, I have a source module where I have raw data (Rows: Flat list of Row Numbers and Columns: All the line items). Line Items: Funds formatted as Fund List, Trans Type formatted as TT list (Investment…
Hi! I've got a list with few properties. I need to get calculations ("calculation" property in the file attached) baced on the the previous calculated value of the same item in the list. Is there any …
Hi team, I have an #Employees list with Selective Access enabled. The Source module has the #Employees list with properties such as Department etc as line items. My target module has Department as a D…
Hey- I am looking to build on a formula in my rolling forecast. I am having trouble laying out the necessary steps. Percentage Seasonality: Each period in a year (12) has an assigned rate. When I roll…
I am trying to do an IF statement within a module dimensionalised by a List ('Volumes') which has 2 members: Retails and Wholesales. I need to do a particular calculation depending on if the 'Volumes'…
Hi, I would like to calculate the YOY-growth % between year to year but it seem I fail to calculate the number even I bring the Previous Value also. Thanks, Kiwi
The MAILTO function currently has a limit of around 2000 characters and any greater than this will prevent the message from being opened in your chosen mail app. This is normally fine for standard Eng…
For those like me who like visual aids, I put together a diagram of when to use sum vs lookup in a formula. Hope this helps if you are struggling when to use each.
Hi, I wish to lookup each and every individual cell in a module that is dimensioned by 2 lists. No time dimension. I have a Module "Sequencing" dimensioned by 2 lists - MonthNames and Offset. Attached…
Alright Anaplanners, we’re giving you direct access to Anaplan experts to answer those tough questions. Is there a formula you are struggling with? What about a list or line item? Getting stumped work…
Hi , I need help on the subject . I would like to give a conditional formula for one of my list properties based on the list subset involved. Please let me know if this possible , if yes, how ? Also i…
It would be useful to have a sum that only included values from list items the user has read access to. So if you have a list with items A, B and C, and one user only has access to A and B, they would…
Hi, I want to create something like the below example, but Anaplan returns circular references. Could you please give me an idea? Example In the above example, I input below formulas Last month stock …
Dear, I am trying to apply a lookup formula to retrieve data but I always get an error message that is not mentioning what is the error. I think my data should be ok, as well as the formula I entered …
For the purpose of calculating lease contracts in IFRS 16 it's sometimes needed to have wide time ranges in the model. Currently, the amount of future years is limited up to 50 years and past years up…
Can we add a number formatting option (text fomatting causes issues for our users) with a default for the cell of blank (if blank then the cell is ignored) and then if a zero is input it is treated as…
On the History tab, provide more data filtering options such as filtering by history action name. For example, my customer needs to filter only user-security related actions for detailed audit history…
