-
Single formula for different list items
Hi, I have a list called Apple having items A,B, A+B. A+B should contain the addition of data of A and B. In the module i have a line item called data and applies to Apple list. I have to write the logic for Data line item such that the module shows up values for A, B and A+B should have addition of values of A and B.…
-
Optimizer - Variables min, max setup
Hi, From the optimizer user guide v01, for variable section, it states the min/max configuration are optional (as below and see the attached full document). So the optimizer has been configured without min/max. However, it flows an error when execute. Then, I configured the Min as zero and it executes successfully. If the…
-
Suggestions for Creating a Data Point on a Version, Based on alternate Version
Our model has three key types of Versions - Actuals, Baselines, and Custom Scenarios. I have multiple Baseline Versions and many more Custom Scenarios - the end-user will be able to select which two they would like to use. My thought is a drop-down List of the Versions for "Baseline" - all other modules on the dashboard…
-
TIMESUM Function with aggregation method AVERAGE
Hi, I am using TIMESUM function with AVERAGE as aggregation method for specific from-to period. Some of the cells have the zero values in it, but this functions is considering those zero cells also into count . This gives me wrong average. How can we skip zero cells and calculate average only for non zero values with…
-
Optimal if statements
I want to make sure that I optimize my if statements, hence some question * If you need to get a maximum of two line items, is it more efficient to use an if statement "if a > b then a else b" or to use the max formula "max(a,b)" * Is there any performance difference in "if x<y then a else b" vs “if y<x then b then a” (in…
-
Retrieve List as Text used in Module
My model has a vintage or "Book Year" dimension which is being used as a list - we model that particular year's performance over time. I'm trying to create a module to result in a Boolean at the intersection of the Book Year and the Calendar year. I'm using a YEAR(ITEM(TIME)) = BookYear. However, I cannot seem to find a…
-
Show the current/logged in user in a single line item
Hi Community, I'm looking for a solution to show the current/logged in user in a single line item that has no dimensionality. The use case for which I'm looking for a solution is a dynamic filter based on the logged in user + to calculate totals based on this filter. More specifically, I have a mapping table dimensioned as…
-
Mapping group
Hi team, I have problem about mapping between entity, entiy(holding) and group. exp: entity H have transaction with entity G, but they in a different group (H in group 3, and G in group 2), we can elimination if H and G in a same group, but group 3 and group 2 in the same group 1, so how to create auto mapping using…
-
Customised Time Scale
Hi All, I have a module with customised timescale. In Module A, dimensioned 24 Week Custom Timescale. In Module B with no dimension, I would like to get Sum of 12 Weeks from Module A. Any leads, please? Thanks.
-
Calculation Inquiry
Hi, PLease see details in the attachment. Regards,
-
Optimizer Exercises - Production Optimization
Hello, I have just done the Optimizer exercises Optimizer: Exercise Walkthrough created by @mark_godfrey , and have an error in the Production Optimization Exercises example. While its possible I messed with the base data, I'm getting exactly the same answer as a colleague. I compared my answer to Optimizer: Use Case…
-
Need Help Regarding NPV
Hi all, I need to replicate the formula from excel of NPV. I've months of first year that sum up to a Year followed by 4 years. Below is the structure of module. Line items are in version dimension - That's a problem too. col- Jan 20...Dec 20 FY1 FY2 FY3 FY4 FY5 NPV Row having no. list I need to apply NPV on yearly level…
-
Decimal Format Issue
Hi All, I am facing a strange issue in Anaplan. Hoping someone can help me with this. I have a calculated % field called 'Calc %' The formal this field is set to 2 decimal points and percentage. I have another input field 'Input %' The formal this field is set to 2 decimal points and percentage This field is used to copy…
-
Circular Reference issue
Hi All, Please see attachment for details. My apologies my post encountered an error so I have to attach the details Regards,
-
Circular Reference Issue in Computation
Hi All, I would like to ask for some insights with a Circular Reference Issue. Here are the details So we have a dimension Unit Mix, where the TOTAL is the Top Level and Parking and Total/ Average is the child. And under Total/Average are child member 1 BR, 2 BR, 3 BR, 4 BR. ( I hope i was able to illustrate the dimension…
-
How to get total count and standard deviation
Can someone please guide me. I have each SKU and would like to get total count and standard deviation. I can get sum but for 7months of data how can I get total count and standard dev?
-
Custom Time Scale - Calendar Month Mapping
Hi All, My model Calendar is 4-4-5. So Dec 30-12-2019 is falling on Jan Month. I want to get Jan month 31 days, Feb - 29( and Feb 2021-28 days), march -31 days,apr -30 days..and so on. The Model calendar follows 4-4-5 Total number of months is not giving the right answer.
-
ITEM(TIME) on Parent Time Items
Hi Team, I'm creating a Time Map module for Time Dimension - Months for a Model Calendar with Weeks with Half-Year Totals selectred The 1st Line Item in my Time Map is ITEM(TIME) which Time Period - Month as the Format & Formulas as the Summary My expectation was that for Parent items, e.g. Half-Year or Year, it would…
-
Forecasting adjustment based on Holiday statistics (sum on specific time items)
Hi all, I have a challenge and I am searching for the best solution. I have (a lot of) sales data and I am using that data to forecast on a daily level for the coming weeks. National holidays have a huge impact on most products the week before and the week after a holiday. I would like that impact to be reflected in the…
-
Help with Sum function / Creating a Profile
Hello I am trying to create a profile to spread revenues by client (i.e. When a client signs a contract in the future, when will the revenues occur based on past performance. First I have a module that has historical revenues, by brand account, plotted on two dimensions - Contract Cohort (month the contract was signed, a…
-
Replace function
Do we have a replace function? I want to change a value.
-
Rename List items
Dear Friends, I need some help from you. I want to update my list. My initial list items (12 list items), will be renamed and a new list will created with the (4 list items).
-
Urgent help assistance
Hi Friends, I am struck with a difficult situation. I have Module 1 and this is the Data Hub and the Date is stored in Text Format. Every quarter I need to pull the data and make it look like Module 2. Now my problem is as the Date is in Text Format, I was trying to find the current year. By converting Text to Number and…
-
Requesting a serious help
Hi Friends, I want to create an Action process. That will automatically import the current year data. Please assist me in this.
-
SUM Parent Item in Hierarchical list
Hi Team, I have an issue whereby I can't SUM from 1 Hierarchical list to 2 different Lists....let me explain with an example I have Source Module which is dimensionalised by #Employee (the parent item of #Employee is Region L1) I have a Target module which is dimensionalised by Clone Region & Budget Owner I have mapping…
-
Inserting a formula
New to anaplan platform, i want to insert the formula in my system module and i know we can search it in anaplan anapedia under all functions tab to see which function to apply. But it's not easy to search for a particular line item. Eg i want to insert formula for years only? boolean formatted line item, so how to find…
-
Calculation on Months to Quarters
Hi , I have 2 lists. Months(1,2,3,45-...etc) and Qtr(1,2,3,4...etc). We need to create module to map months to Qtrs. That is for 3 months in one Qtr. That is for month values 1,2,3 The Qtr value should be 1, For month values 4,5,6, the Qtr value should be 2 and so on. Please let me know if there is detailed method how to…
-
Find the minimum 'Month' across multiple Line Items within the same module
Hi, Apologies if this doesn't make much sense but I am fairly new to Anaplan. I have a module with multiple line items, each retrieving a month from other modules (Formatted to Time Period: Month). I would now like another Line Item (within the same module) to calculate the 'MIN' of those line items. Is this possible? I…
-
How to create formula for YTD and YTG run rate (Moving average)
Hi I would like to create formula to calculate moving average for YTD and YTG. Here's the formula i input MOVINGSUM(Actual, -11, 0, AVERAGE) to calcuate YTD run rate, MOVINGSUM(Remaining, -11, 0, AVERAGE) to calculate YTG run rate but the it doesn't seem correct to calculate the moving average. Kindly see example from file…
-
Compare Amount
Hi, I have line item (status interco) where if amount blue and red not same it will be give text "Unbalance" but i dont know how to compare every item Any ideas are appreciated. Thanks,