-
FINDITEM multiple columns
Hello All, I was wondering if there is a way we can use FINDITEM to find a value from multiple columns. The way FINDITEM works is by comparing a list with a specific line item (column). However, in this case, I need to be able to find an item that may be in column 1 or column 2 or 3. Is there a way to achieve this? Any…
-
How to achieve Different Granularity in a line item based on the version?
Dear experts, We have a requirement to have to different granularity of data in a same line item based on the version selection. Detailed explanation: The line item has following granularity of data: Version = Actual; then the granularity becomes Potline (Parent of Potline Group, This data comes from Data Hub). Version =…
-
Can we have 2 DCA for one line item?
Scenario - At the UX level , a user will come and input a value in the line item(For example KPI). This KPI is different across different geographies. So a user can only edit KPI from his/her region. In order to do that I set DCA at the KPI level. Now once the user has put the value, manager will come to review and if all…
-
Forecast in foreign currency - do others do this?
We are beginning our initial Anaplan build now for forecast, and we're trying to determine the best way to dollarize our unit forecast in appropriate foreign currencies and then roll up to a USD forecast. We're working with a business partner to implement, but our internal IT team is questioning if this is core Anaplan…
-
Change Order and Style of Line Item Subsets
Hello, I am looking for some help. I have a module, call it "Module A", which feeds a Line Items Subset, call it "LIS A". I used the "LIS A" to populate an end state report, call it "Module B". How can I change the order and styles of the LIS A points in Module B? When i make the edits (reordering of lines or changing…
-
DATA IN MONTHS AVERAGE OF 4 MONTHS REQUIRED
I have a query, that i am having data in months and count is the line item.how can i average 4 months of that data. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec FY22 120 123 140 145 150 60 70 80 86 78 79 80 ---- so Iam excepting output Average of 4 Months? Jan Feb Mar Apr ? ? ? ? And what format can i take for this of…
-
Best way to have a daily model in Anaplan
Hi, I'm creating a Daily model in Anaplan that needs to skip over weekends and Holidays. Instead of putting a formula in every LI. What would the best way to approach this? Should I be by creating a LI in the SYS's module that has this formula that will skip over weekends and Holidays and then call upon that formula? Or is…
-
Manual Entry
Hi all, Is there any possibility for manually entering and using formula in same line item... Knowing its not possible still is there any possibility for the same .... Regards, JEEVAK
-
Disaggregation
Hi Experts I want to Learn About Disaggregation can You Please Guide From Where I can Learn . Thanks In Advance .
-
How to link a property/line item on modules with different dimension
Hi, I need to get data from a line item from one module with a different dimension with my target module, I cannot do a lookup because the 2 dimensions are not totally related. See details below ; I need to get the Position value from the source to the target, as you can see in the target module, not all Position list is…
-
Simplifying a formula with multiple checks for User Input
Hi, I have a grid in which there are multiple line items (approx. 25). These line items are user inputs and when the user enters these either manually or through file upload, he sees a validation message that checks his input related to multiple conditions (e.g. Invalid Date, Mandatory Field Blank, Duplicate Entry etc.) .…
-
Calculate Cashflow on the basis of IRR set by the user
In Excel we have Goal Seek function to set Target value of a calculated cell and based on that target value, excel performs reverse calculations and gives source value needed to achieve the target. Now, in Anaplan I want to achieve this similar functionality. IRR is an Anaplan function resulting in value calculated from…
-
Is there a way to turn off the calculations done on Summary Methods in Snapshots?
Is there a way to turn off the calculations done on Summary Methods in Snapshots? Currently I am having an issue with the rollups on the snapshots because of the Summary Methods on the Snapshot module. For example: a line on a module has summary method of 'Formula' but the Snapshot has a method of 'SUM' so this is causing…
-
Formula and Ability to Edit
Hello, is it possible to have a formula that is formulated for a certain version or from an IF, but then allows you to hard code if that is not true? For example if we were to say "IF ISACTUALVERSION() THEN 0 ELSE {Ability to hardcode here}" Thanks in advance
-
formula revision for QTR last year
Hi Community, I would like to ask advice on formula revision of my clients report. Below is the target module. The column of last year is where we are encountering a problem. Requirement: it is supposed to pick up the value from the source module but the total QTR of last year. Target module: OUT007 In the target module if…
-
Multiple data write actions per button press
Hi all, I have a button that updates a boolean line item in order to change the status of something. Is there a way to have it so when I press the button, it sets multiple line items boolean's? Ideally I'd like it to update multiple line items from one button press. Thanks, Sam
-
Formula Help
Hi, Need help creating a formula that will look at LI for a rolling 5 day forecast and return back the max number of those 5 days. I set up a systems module that looks at the forecast for 5 days, and then tried to use it in the formula below.
-
Fastest way to replicate changes in SYS Property modules
Hi Everyone, I need your help to replicate same changes from one SYS module to some of the SYS modules. Let's say I add some line items in one SYS module and there are 30+ similar SYS modules. Is there a quick way to replicate these changes in other modules so that name, format, formula and summary settings can be updated…
-
Detect CRLF character in a text line item
I have to replace CRLF (carriage return / line feed) characteres form a text line item. How can I use the FIND function or more better the SUBSTITUE function to replace such a CRLF char. Result = SUBSTITUE(line item to replace, CRLF character, " ")
-
Prior financial year result
Is there a formula that can be used to get the prior financial year (full year) P&L? Question/Context: If we have set-up Anaplan with correct time dimensions how can we get the prior year result in the current year. Example in July 2022 how can we pull in the FY22 (assume March year-end) P&L total and continue to pull that…
-
Time Setting
Hello Community, I have created a module where I have set Fiscal Year Start Month as "April" There is some module where I need month to be started from "January"... What is the solution? Thanks in Adavance Regards, Jeeva K
-
unable to get access anaplan
i have credentials to log in anaplan community.but while log in to the worksapce by using same credentials it showing as incorrect .while going to password reset, unble to get reset password to the mail id. please do needful.
-
Boolean, lookup and lists
I am stuck - I have a Boolean that I want to populate based off the value in a given list. If this was excel I would write the formula as If Pay type = H then True else false. But I know that I can't do that. So I moved on to thinking I need to use the lookup function, but I am at a loss on the syntax to ensure it is a…
-
Driver Calc help with logic
I have a driver called "set to plan" which is just assigning the planned amounts to the forecast periods, but this is only happening for 2022 forecast periods. The previous driver Calc: IF Driver Method <> 'SYS002 - Model Lookups'.Set to PlanTHEN 0ELSE 'REP001 - Balance Sheet (Reporting Output)'.Amount[LOOKUP: 'SYS006 -…
-
Today's Date
Hi, How can i refer Today's Date in a formula so as the values would change every day based on that days date. For e.g. if its 09th june then the formula should give result as 09th june . The next day i.e. 10th june the value should get updated to 10th june. Is there any such functionality or formula available inside…
-
Selective access in dropdown list
Hi, How can i apply the selective access write only in my dropdown list ? I have a list with selective access both write and read and in my dropdown list i only want to allow users to select those members that they have write access. Thanks in advance for helping. Regards, Tom
-
Rename a list item through a NUX page
Hi Everyone, Is there a way to rename a list item through a NUX page? Thanks! - Shubham
-
Sum over a specific periode
I need to sum values inputed in months into a line item independent from time over a specific time period already determined by start and end date how can i do that please ???
-
User based calculations
Hello - I have a question which ultimately is related to using the users list in module design. Was hoping someone could confirm my theory, or even better, provide a more efficient way to set this up. Here are the details on what I'm dealing with: We have a module setup for budget vs. actual analysis, in which the module…
-
Text Based Line Item Subset/Page Selector Filter
So I have project list. A module which captures weekly update of the project, its not dimensioned by time. I record the previous weeks updates using an action, avoiding time completely. Currently i have 10 line items in my module which captures previous week's updates. Is there a way i can give a view to the end user where…