-
Nested IF statement replacement
I am looking for a best practice for the following. I have a driver-based model where the user selects a driver from a list of possible options. The user requirement is to use a check box to make the selection. The module displays the options, the check boxes, and the result. I am looking for a better way to arrive at the…
-
How to apply conditional formatting based on total?
I have a module dimensioned by L2 SubFunction list. I need to apply conditional formatting based on the total of all functions(ie., L1 Function summary). If all functions =100% green else red. How do I do this given that all functions is not a line item but the L1 Function summary.
-
Anaplan ALM Process
Hi, Our Anaplan Workspace environment is DEV - Prod. I have made changes to a process in Dev workspace. I need to move these changes to Prod Workspace. Here are the things I did. In Dev Workspace - Made changes for a process in a model. In Dev Workspace - Created a Revision Tag. In Prod Workspace - I used copy and Archive…
-
Minesweeper: How we Built it?
Do you remember the good old days when we used to play games like Solitaire, Minesweeper, Pin Ball, Checkers, etc in your big and bulgy desktop? Oh! Those were the golden times of youth, even though we cannot match the high-end technological development in graphics, storyline, real life game play, regular updates but the…
-
How to fetch unique value using textlist function from child level to parent level
Hi, I need help to get unique values using textlist There is System module SYS01 at child level dimension with List A, I need fetch text value from line item X in SYS01 to Line item Y in SYS02 . The SYS02 module has dimension B which is parent of list A. While using Textlist function Im getting error: 'SYS01'.Parent is not…
-
how to do provision payout id generation in anaplan model
-
Sample Reporting Template on Merging the models
Good Day All I m looking for a sample report template on the assessment of incorporating two models into one ( like workspace optimization, impacts, and advantage ). Can anyone help to share the same? Thanks in advance
-
Sample Reporting
Good Day All I m looking for a sample report template on the assessment of incorporating two models into one ( like workspace optimization, impacts, and advantage ). Can anyone help to share the same? Thanks in advance.
-
Different formula for different selected version
Hi, I have 5 different versions in my model, Actual, High, Low, Mid, Budget Q and Budget FY. I need to apply a lag a figure one month to the first 4 versions and for version Budget FY, I need to take the months value not the lag. I have configured a custom versions module as well as attempted a boolean approach but am yet…
-
Xlookup in Anaplan
Background: have a strange 2-level hierarchy where items are at the top level if they have any children, and they are at the 2nd level if they have any parents. I have many items that exist at both the top level and lower level of the hierarchy, up to 5 levels deep (but only 2 levels ever show up in the parent to child…
-
How to convert Month to year (Ex: Apr 22-Mar 23 to FY 22as year)
Hi Everyone, Is there any method that we can convert month to year, as i have scenario like timescale was APR 22 to Mar 23 as text formatted line item and we need to get a time period format as year and value would be as FY 22. Any Advice. Thanks
-
Any idea for getting current date that always up to date in Anaplan
I need an idea for getting current date in Anaplan.
-
ALM | Unable to sync | Error occurred "Sorry, null has been deleted"
Hi Anaplan Team, Good day! I would like to seek for your assistance to identify the cause- why we are getting the attached error in Anaplan and on how we can avoid getting this error while syncing. Thank you so much! Rachelle
-
How to merge two models into one?
Hello Team, Would like to check on the following : There is Product standalone report exists in two models. I would like to merge into one model for space optimization. what are the steps to be followed? An leads or advise on how to proceed this? Thanks in advance.
-
How can i get the crossover by function
Hi , As per the screen shot, in the left grid whenever i select the y the the left grid should show the same year start month and end month and if i select the y-1 ans week 44 the value then the right side grid should show the 2022 and 44 the week month +1 year how can i achevie this in a simple way
-
How to update cell values based on different criteria
Dear all, First of all, thank you all for all the support you provide here. It has been very useful in my training journey. Now I am working on a report where I have to put data based on % value, so the total % is in a line item and in new line item, I am trying to rank it based on %. I am trying below formula, but it…
-
Using numbered transactional list vs. normal list with unique id (concatenated)
I came across a model where all the transactional files are loaded into a numbered list, using the combination of properties (like period, cost center/profit center, company) for uniqueness. I understand the best practice would be to load these files into a flat list, using a unique id which, in this case, would have to be…
-
Multiple information columns prior to Time Periods columns
Hi, Asking for some general advice on how best to manage this. We have several schedules in Excel which show mutliple information columns prior to the Time Period Columns. Eg. Project Name | Project Type | Product | Start Date | End Date | Jan 22 | Feb 22 | Mar 22 | Apr 22| etc..... There are several tables like this that…
-
Stress Testing on Anaplan ICAAP/ICARA
Hey Everyone, I'm just wondering if anyone has tried to use Anaplan for stress testing? How did you go about it and was it advantageous to use Anaplan over something more flexible like excel? If it was advantageous how so? Thank you, Padraig
-
How to add boolean as true above intersection of same month
Hi Everyone, I have a module with 2 dimension & 1 Line item. Dimension 1 - Anaplan Month time (In columns) Dimension 2 - Time List ( In Rows : Similar to Anaplan time month) Line item name - Boolean up true. In Time List , I have 5 months: Jan 22 Feb 22 Mar 22 Apr 22 May 22 Now , please see the attached Image. The way you…