-
Error with line item is not recognized
I'm try to find medical cost for employee in EMP02 (Employee Expenses) drives by Role and Department where i have to reference to EMP03 (Employee Driver by Role) and SYS08 Employee details. In my formula I didn't query direct EMP03 source module into target module EMP02 is because in EMP02 I don't have Department and Role…
-
Median Calculation on Multiple Dimensions
Hello - has any one ever successfully been able to calculate the median off of multiple dimensions? I have a list of customer spend data at the customer level and would like to calculate the median by certain attributes of those customers. For example, I have 10 customers all who belong to different countries, and…
-
How to return the month/time period of other line itme
Hello, I have a module with two line items. This module has product list on pages and line items on rows. 'Max Slots' has a formula that returns the MAX value of a given product from another module. For the other line item 'when' I am trying to return the month or time period that the MAX value takes place. I am trying…
-
Major UX Page Release! VARIANCE ANALYSIS...directly in UX page!
Yes! You can now do ad-hoc variance analysis! I'm about to jump into this right now and test it out - this is a huge addition to the reporting and ad-hoc functionality. Take a look below to hear directly from the product team and check it out. Please comment if you like this - I am really excited about the options this…
-
Formula error while pulling data from one module to another
Hello, My goal is to get the 'total volume' of product being used for certain year by different cities. Below are the two data set which have been successfully mapped into Anaplan I want to pull data from DATA02 into REV02 to achieve my goal. SOURCE DATA02- (data SKU Volumes) TARGET: REV02- (data Volume Inputs) I tried…
-
Import Data applying DCA
Hi, When i import my data, my DCA is not working, how can i activate my DCA so the import would not allow to change the data. Thanks, Tom
-
Last Workday of the month
How would I create a Boolean line item that would select the last work day of the month? Thanks
-
Parent to Child Mapping
Hi, Is there a way to map a selection made at the parent level to all the children of the parent? Product Hierarchy: L1 Program, L2 SKU My final output report is at the L2 SKU level. The users take multiple snapshots of this report during planning cycle. At the end of the cycle they want to select a final snapshot for that…
-
Advise on building methodology
Hi, Im trying to build out in Anaplan a way to take all the totals of the first day of each month and then divide it by the totals of the whole month. This will give me a ratio that is needed to multiply by each dayified first day of the month. Thank you
-
LAG() Rent Increases without Time Scale
Hello, New Model Builder here! I'm working to enhance an older model that uses a hierarchical list as a Custom Time Scale (CTS Months). The list is used in lieu of a time scale for most modules, however one of the enhancements involves applying market rent increases to the next 'time period'. i.e. a 5% market rent increase…
-
Data type mismatch: format other than LIST or DATE being referenced as a relation
this is the formula IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role,LOOKUP: 'SYS08 Employee Details'.Department] ELSE 0
-
12.4.4 Activity: Create Saved View for Profit & Loss Report
this is actual which should have 0 as given
-
How to lookup a value from a source with no time
Context * My Destination module has the following dimensions: (1) Employee ID (2) Line Items (3) Time * My Source module has the following dimensions: (1) Movement Code (2) Line Items* Employee ID is a line item (List) * Effective Date is a line item (Date) Goal * In the destination module, populate an employee's job level…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
my resultthe lesson result
-
Look up for future periods
Hello, What's the formula for looking up only future periods? In our module Professional Services Forecasting, I have actuals up to and including current period and blue inputs for forecast / future periods. We then have a module that groups various job codes called Professional Services Profitability. This already splits…
-
12.4.4 Activity: Create Saved View for Profit & Loss Report
the result displays the actual version whereas it should show only the budget and forecast version the lesson reslutmy result
-
Data from Line Item Subset back to original line item
Hi, How can i get back the data from Line item subset back to the original line item? I used the LIS as my dropdown to another module and i want to consolidate back the data from the dropdown to my main module. Thanks, Tom
-
Regarding 80000 Character Limit in Mailto function.
Hi, Can anyone please clarify whether spaces and newlines are counted as a character in the 80000 character limit in browser? Thanks and regards, Aakash Sachdeva
-
Referencing List Items in Formula
I have module D03 that shows how many slots each product family uses. D03 is dimensioned by Time on rows, and PR2 Product Family list and 1 line item 'Slots' on columns. I am trying to write a formula that 1. references data from another module, and 2. does some calculations for all the data in each item for PR2 Product…
-
Can module 'Applies To' have multiple lists from the same hierarchy?
I have created Line Item subsets and certain modules for filters for other modules. My ultimate goal is to assign different line items to different list items (across the hierarchy as well). I have P1 Product Lines, P2 Product Families, and P3 Product Names. I have module D07 which shows how many slots each of P2 Family…
-
Looking up Day of the Week list for a LI in a different module
Hi, I'm trying to be able to look up a total for all the individual days of the week from my historical data. i.e, I would need to look up all the Mondays in the Month of July and sum them together. I have weekdays as a list but I'm getting a error message when I try to use LOOKUP, SELECT, or SUM. Please advise. Blue Print…
-
Chart UX Constant/Module Calculations
Hello, I am trying to build out a very specific UX dashboard. I am trying to create a chart that displays all the data from a single list AND also add one additional data row that is from another module. Module 1: D01 Slots Pages: Version, Locations, Teams, Resources Column: Time Rows: Slots (Line Item), Products (20+…
-
haschildren(List)
There should be a haschildren() function that takes in a list that a module is dimensioned by and returns a boolean, indicating whether or not the list member has a child. This would be especially useful in conditional formatting with multiple dimensions, where for one of the dimensions, you do not want the conditional…
-
10.2.6 Activity: Add Formulas to Employee Expenses Module
Hello, Anyone Can help me to figure out the error in Bonus, not sure where I am mistaking it. I tried both way Copy and Paste the formula also written it. However, still have having same issue. Please find the attached screenshots. Thanks.
-
The values doesn't appear in Gridview
I use the same formula to calculate a value in a line item, it works in one module (Sales Qty - Motor) but it doesn't work in other modules (Sales Qty - Mobil and Sales Qty - Truck). I use different subsets from the same list for each module. Blueprint of Module 'Sales Qty - Motor' Gridview of 'Sales Qty - Motor' I use a…
-
Is there a function that checks the name of a list item in a module and returns specific data?
Hello, I am trying to build a UX dashboard that displays data from two different modules. In D01 Slots (PAGES: Version, Locations, Resource Groups, and Teams. COLUMNS: Time. ROWS: Product Names and one line item "Slots"). Module D01 allows me to see the number of slots each product uses. In D02 (PAGES: Version, Locations,…
-
Formula Calculation
I am writing calculation formula which I am struggle a little, hoping anyone can help me out. When writing calculation formula in Excel, we can use ( ) to group the calculation together, but Anaplan does not work the same way or am I work? Is there a way to group calculation together within Anaplan? Thanks in advance,
-
Version
Hello Community, I have one module with version as dimension. In resultant module no version dimension is used How it is possible to flow value to resultant module..... Thankyou In advance Regards, JEEVAK
-
Trying to look up a LI for the previous 6 month average
Hi, I'm trying to look up a LI for the previous 6 months average using a TIMESUM. The formula is working but no numbers are appearing. Not sure why the numbers are not appearing. The formula is below. Thank you
-
What is the best function on the below use case: TimeSum or MovingSum ? (For best performance)
Hi, Generally it is suggested to use the TimeSum function if my target is not dimensioned by time. If my target is dimensioned by time, it is better to use MovingSum. But MovingSum doesn't allow start period parameter other than the number data type. What can we do if my target is dimensioned by time and my start period…