-
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 -…
-
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…
-
Previous Year to Date Calculation
Hi everyone, I am in need of a formula for specific line items from our P&L that calculates the previous year's YTD values. For example our YTD currently shows Jan 22 - May 22. Ideally I could have a separate model to choose each line item and show the YTD for Jan 21 - May 21. Is this possible?
-
4 Quarter Average for a year
How to get 4 quarter average of the same year for all quarters in a separate line item(Quarter formatted) Thanks.
-
Percentage format, eMail body, TEXT Function
Anaplanners, Running into a rather simple issue, wanted to use the anaplan mail to function with the body picking up few data from the module, for example: - Marks obtained by each student is stored in line item called 'STUD1.1 Student Details'.Marks Marks Obtained = 70% Now my mail body formula would be "Marks Obtained =…
-
Error: Dimension of mapping used for lookup doesn't match any dimension of the result
Hi gurus, When building the reporting module 'REP04'(the target) I've tried to reference an existing module 'EMP03' (the source) for the calculated medical costs. REP04 has two dimensions 'Region' and 'Role' whilst EMP03 has 'Department' and 'Role', hence I tried the mapping module 'SYS08' to fill the gap. Thought it's ok…
-
Add a dependent to the listings with Top Level.
hi! I want to add a dependent to the listings with Top Level. I would like to prevent TopLevel from being selected in the pull-down. How to do it？ Please help me.
-
Lookup function help
Hi.... I need some support in creating a formula to for a look up I have created a mapping module where: 00.nondefault is a list Stage 1/2/3 is a list Y/N is a list Line item is boolean I need to map it to another module so that in the Anaplan classification it identify whether it is stage 1/2/3- not sold etc. I have…
-
Time Format in Jan,2021 Feb,2021,Mar,2021
How can i change this date format, can anyone please guide date format
-
Calculation of Payment Frequecy
Hi All, I've one use case where I've to calculated payment according to payment frequency i.e monthly, annually and quarterly. I've system module dimensioned by lease where user enters lease start date, end date and payment frequency. For e.g. Sr. No Start date End Date Payment frequency Lease1 4th-May-2012 12th-july-2022…
-
Getting zeros when using the LOOKUP function
Hi! I am getting zeros in my data when I am using the LOOKUP function. What are the possible reasons for this? I am sure that I am using the function correct. The function works but the data only shows zeros.
-
Lookup based on a boolean line item
Hi, I have a target module INP01 with 5 dimensions (P1, C5, Size&BPC, Time, and Deal Levels) and I need to bring values from another module DAT05 which has 4 dimensions (P1, C3, Size&BPC and Time) The point is that it needs to be done based on a boolean line item selected month? in DAT05 (which is true for the month…
-
Identifying list members with booleans
Hi, I need to identify list members using a boolean. (What I tried is at the bottom) In a system module SYS06, I have a line item "P2 Product Brand" that is populated using a list (shown in photo 1), it is list formatted. Photo 1 then, I created a boolean line item that is intended to check in another module SYS03 (Photo…
-
How to sum time ranges
I have a problem when aggregating lineitem by time . I want to aggregate Amount by "Aggregate Lineitem" (From Jan-21 To Mar-21). The Module A&B has set by time range, so we can't do it. Table A ( Time Range : past 2years) ListMonthJan-21Feb-21Mar-21Apr-21May-21LineitemAmount A100200300400500 Aggregate✔✔✔ Amount…