-
Calculate Inventory Catch up date
Hi Is there any way or function to calculate inventory catch up date? i want to calculate 1st date that recover the sales plan. Jul 01Jul 02Jul 03Jul 04Jul 05Jul 06Jul 07Jul 08Sales 20 10 Production 10 20Inventory -20-20-10-10-200Catch Up Date Jul 08 Jul 08 in this case, sales of july 03 will be recovered by july 05…
-
Function to get Current User Details
Hi, Is there a way to get the First Name and Last Name of Users? Thanks, Dennis
-
How to inherit parent value?
Hi, I am a beginner in Anaplan. I created five lists which have 'currency' in its property tab for organization hierarchy. (LV1 though LV5 and LV5 is the most detailed list) I noticed that LV3 'currency' value of property tab is not inherited to LV4 and LV5. *LV3 is parent of LV4 I tried to put formula for the LV4…
-
Selectively tally rows from a module based on '(column name) IS x', or similar
I'm trying to write a formula in the module 'Spend (FY18)', that refers 'Budget (FY18)'. I want the formula to check the column 'Period' (which is a pick-list of four options) and if that period equals Q1, it will take the £amount from that row, and add all such rows together to give a £total for that Quarter (repeat for…
-
How to calculate NPV in Anaplan to match Excel's NPV?
Since the current NPV formula in Anaplan is similar to Excel's XNPV, Anaplan NPV results can fail to match Excel NPV results. This situation can lead to a lack of confidence in Anaplan's calculations when they are compared to an established Excel workbook model. Is there a method within Anaplan that can be deployed so…
-
Workaround for version formatted line items
Hello All, This is my issue: - I have a module called "Billings" where I have my billings by version (version A, version B and version C) - I would like the end user to select a version (A, B or C) - Ideally from a dropdown - Then, I want to create a line item (it can be in a different module) called "Billings (from…
-
Process in production
Hi, Could anyone please tell me, how we can run a deletion process (Deletion from list using selection) in deployed mode.
-
Implementing sumif in Anaplan using two different modules
I have one module containing of data from January 2010 to December 2020. In another module my dimension is not the Time period but a defined list of months. In these 12 columns of the second module, I want sum of January figures from data module to come in January column, sum of February figures from data module in…
-
Profile Function - Pulling apart the components of an aggregated sum
I am trying to pull apart the components of a profile function so I can understand the impact of a certain period. Example - I have a ratable revenue recognition treatment for my bookings and I would like to understand the impact of Q1's bookings in Q4. By the time we get to Q4 we have now layered on Q2 - Q4. Is there a…
-
How to replace a last period with a switchover?
Hi team, I got a problem with a switchover when I can not replace the last period on the time scale with an actual version. I have two versions: Plan and Actual for one-year timescale Jul'16-Jun'17. I have been replacing the plan version with a switchover each month. When my last month has been closed I had no option to…
-
Zero needs to be shown instead of 'Infinity'
Hi, 'Infinity' has been returned as the result of MIN function as the attached screenshot. What should I do so that Zero value can be shown instead of 'Infinity'? Best regards, Maki Yasuda
-
How do I calculate months between Start Date and End Date?
How do I calculate months between Start Date and End Date?
-
How to Calculate Months Difference between Two Dates
Does anyone know how to calculate the number of months between two dates? Calculating the days is easy per my formula in the image below.
-
SUM Mapping for Top-Level Items
If a list of items are assigned to a top-level item in another list, the items are not counted when the SUM function is used. For example, there is a module with a list of events and a line item called "Assignment", which is a list format connecting to a list named "People". Some events are assigned to "All People", which…
-
Default version when source for not-versioned module
Hi, I noticed that when a target module of a formula does not have versions but source module does, a Forecast version (the one marked as current) is always picked up by the formula by default (merged with Actual), no matter how many further versions exist in the model. Is it a default behaviour that I can rely on? I know…
-
Bulk model copy
HI Team, I need to move multiple archived models from one workspace to another. Is there a way where I can move multiple models simultenously to the new destination workspace or should it be done manually one model at a time? Regards, Prateek
-
Calculations using Dates
I need help developing a formula that looks at the start and end dates for an agreement (eg. rent, where rent amount per month is fixed). The agreement can straddle months or years. I would like to show rent mont by month on a timescale, however, be able to prorate the rental amount in the initial month and the final month…
-
Compounding Monthly Growth
Relatively new user and am struggling to build a ramping growth model based on monthly expansion. Am using the lag function in this context: Avg Deal Size = LAG(Avg Deal Size, -1, AEC Salesperson Assumptions.Starting Deal Size) * (1 + Deal Size Growth) My Deal Size Growth is positive and my overall Avg Deal Size is…
-
Data Types Conversion - manual
Hi everyone, A new video tutorial on how to convert most used data types is available here. Hope this will be helpful, Egor.
-
linitem options (Start of section, Brought forward)
Help me please with use cases for linetem options: Start of section, Brought forward In Anapedia it's said they are rarely used and I couldn't get enough from explanation think if they present in blueprint it will be helpfull to understand where could I use them
-
Formula for blank value in lookup function
Hi I am using the below formula for one of my line item in my module 'Demand'. I am doing a look up in another module 'Open Qty by Bucket ID' by Bucket ID and SKU to populate the open qty value in the 'Demand' module. Open Qty by Bucket ID.Open Qty[LOOKUP: Bucket ID LF, LOOKUP: SKU LF] The issue I see here is,if there is…
-
Tableau 10.2 to make advanced analytics easier for enterprises
Tableau 10.2 adds advanced mapping capabilities that claims to make data analytics easier and more scalable for enterprises. Intro: Data visualization company, Tableau software, has announced the overall availability of its new version, Tableau 10.2. The organization states that the release includes advanced mapping…
-
Help with NPV Function: Anaplan differing from Excel
I am having trouble with the results of the NPV function in Anaplan versus that of Excel. In anaplan, I cannot control the scope of the time periods being passed into the NPV function. I am expecting a value beginning in Q2 FY18. However, the calculation returns a value beginning in Q1 FY17. My client is expecting the…
-
Profile Example
Can someone provide the example of using Profile function in Anaplan, I need to spread the value between two dates? for eg: Start date 1/Jan/15 to 1/dec/2015 - value is 12, spread should 1 each month. regards, yagna.
-
List subset by formula
Dear gurus, I'd like to create inventory report and included "Item master" as dimension. However, since there is no stock in 50% of item master, it is obviously waste of cells. So, I'd like to create list or list subset based on "existing stock only". One of idea is to create simple module with item master, and…
-
how i calcuate duration(in months) between two months
hey, i have an issue that is related to calculation of month. actually my line item which name is start month and End month that format is month(year). so with this how i calcuate duration(in months) between these Months. With this post i am attaching Screenshot Of Blueprint of my module.
-
Leveraging Excel File with Formulae
Hi all, I am in possession of an Excel file which for the purposes of documentation, has a list of all accounts and their respective formulae. For example, a line may have: Name: Code: [OpStatement100] Formulae: [Opstatement50 x Opstatement75] (anything within square brackets is the literal text of what is withing the cell…
-
Child to Parent Ratio based on Planned Input Number
Hello I have a set of Actuals(FTE) by Level 3 rolling up to a Level 2 in turn rolling up to a Level 1. I need a formula that calculates the ratio to its immediate Parent first . I also am looking for a mechanism where someone enters a new value at level 2 (immediate parent) the new planned numbers for service level 3…
-
Yearvalue and select
Dear all, is there somehow the possbility to use the yearvalue- and the select-function together? I want to transform year values to a monthly schedule and thereby just select a certain case from a list. Thanks you all in advance, Best regards
-
Semi solution
I have been thinking about the issue and I found a solution, however to keep it feasible with formula's limiting the IF-function, I need a bit more help. Currently my solution is to recalculate the percentages in the final module, however I need IF function for every line item, as all of them are calculated differntly. For…