-
Another Circular Reference Question
I am building a Cost Forecasting Model which uses different methods for calculating the forecasted amount depending on the cost category and the number of years into the future. One of the latest use cases is to be able to taken the calculated cost from the previous year, increase it by inflation and divide by 12 to give…
-
level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line
level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line items. Open the REV03 Margin Calculation module. Toggle to blueprint view to enter the following formulas for each line item: Line ItemFormulaRevenue'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Sales Price * (1 + Sales…
-
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…