-
7.2.2
I am getting errors when I am trying to put in the formulas. Check Photo
-
Create range based on input line item
Hi , Please help/advise on how I can create a condition where we can automatically calculate our rebate based on the uploaded volume. I created a separate list where i define the range and the corresponding rebate. In my calculation module, i need to lookup the rebate based on the volume that was uploaded. My problem is…
-
2.3.8.4 - % by week
Hi - how far off am I this being correct? 'DEM01 Volume Growth Rates'.Growth % * 12 / 52
-
7.2.1
I am getting an error message while trying to map the data.
-
7.2.3
I am a little confused on the mapping. It brings up time but I do not know how to get rid of time as a dimension.
-
Removing Summary Method from Module
I am stuck trying to correct my DEM04 Demand Export Module. I cannot get rid of the time summary columns in the module. I have all summary methods for every line item set to none. I also added a time settings filter for "Months Only?". Yet the half year and full year summary columns still appear in the module. This leads…
-
List item to line item (without using select function)
Hello There is a module having Account list(30 list items) with balance line item. Another module having 10 line items (which need to fetch data from 10 list items from Accounts list) used select function to refer data(which is not a best practice) [ex:balance from 1st module[select:list item]] Is there any option other…
-
Simple formula question for extra dimension
Hi Anaplan Community, I was wondering if any one can help me out with a simple formula issue. I am linking a field from one module to another module (within the same model). The problem is that the destination module has an extra dimension. When I create the formula to link to the other module (using a sum function on a…
-
How to use SUM with the Users list? Why invalid?
I have a situation where I am trying to create a summary values for the Users list and have them be arranged by a 'type' mapping. I have a mapping module dimensioned by users and my 'product' list, with a list formatted line item to determine if it is applicable to them and what type it is for them, and I was hoping to use…
-
Filter line Item
So I have a module wherein there is 13 line items. 1 is a Text Line Item (text formatted) and the other 12 are Jan Feb.. Dec (12 months number formatted). I'm not using the native Anaplan time. I however want to filter the display of months based on the version selected (not native version). Say if it's Version 1+11 which…
-
User List with LOOKUP function
Hi, I am trying to use standard users list with LOOKUP function, but i am getting an error "Invalid use of "Users" list with function 'LOOKUP'. I can see many posts in community says Anaplan looking into this enhancement. Is it real?, If yes. does any one have an Idea when it will be released. I appreciate your reply.…
-
Unable to drill down: transaction module and line items must apply to a single list.
Dear Community, Does the drill down to transaction work only when then source has limited dimensions (e.g. one list, time, and line items)? My source contains: one list, time and line items. I was able to use drill down to transaction in my summary module. Then I added a dimension to my source module (a synthetic version…
-
Retrieve Users with Write Access from User List
We have built a dummy User List in system, selective access enabled, so user can set write access to those users. Is there anyway to directly retrieve the list of users who have write access? Attached pic to illustrate the purpose: User2 was given write access to User1 User3 and User2 itself, we'd like to get a list of…
-
Importing data with dates and multi-currencies
Hi please refer the following attached screenshots: 210325 Line Items 210325 Line Items (alternative view) 210325 Line Items (Data Import) 210325 Import with Failures 210325 Import with Failures Details Situation: To import data from a flat file comprising dates, names and billing rates in different (foreign) currencies…
-
TAR01 Detailed Sales Targets
Hi, I want to make sure I'm understanding the intended logic of the TAR01 Detailed Sales Targets module. From the user story it says, "I will know this is complete when I can see the percentage of the country’s actual sales revenue by product family that each account’s actual product sales contributed to per quarter." So…
-
lookup and error message
Hi Please advise on what this error means : lookup error - please see image attached - thank you IF Employed? THEN 'EMP03 Employee Drivers By Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 data type mismatch : format other than LIST or DATE being referenced as…
-
4.6.7
Every time to run my import it says that there are errors and my order for the source is column 1: Product Code, column 3: family code and column 1: product code and I know this is right because this is the same thing that other people have used and they got it right but when I run it it says that there is an error and the…
-
Trouble Finding a way to Convert Values from Half Year to Weekly Values
I am working through Level 2 Sprint 3 training and I am having trouble with creating a formula to convert data stored on a half year time scale to a weekly time scale. I would assume weekvalue('SOURCE Line Item') would be the correct function but I am not getting any values. I have changed the time summary method on the…
-
Sum values from all Versions
Hi, I am trying to sum the total value from one line item for all versions. The source module contains versions and the module containing the calculation does not have versions. The formula I used references the source module and line item and returns the value from the current version only. Is there a formula that can be…
-
Level 3 - Sprint 1 (4.6.5) - Lookup isn't working correctly
Hi, I'm a little stuck on Level 3 print 1 section 4.6.5. The formula I'm using looks correct but the lookup to accounts section isn't returning the correct values for me. 'Data_01_ FY19_Sales_Revenue'.Actuals[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS00 Time Settings'.PY Qtr] This is the formula I'm…
-
List properties in a Module
Hi All, I am working on a model where I have a list with 3 properties(B,C , D). List AProperty BProperty CProperty Duxyz In a module with Dimension as List A the below mentioned format is to be generated where in a column corresponding to the above mentioned list items all 3 properties can be brought: Module with Dimension…
-
Reference next item in a list
is there anyway to reference the next or previous item in a list by using a formula? I saw a post a while ago that inferred that this was not possible without quite a bit of conversion logic. thanks, josh
-
Sum data from a module with line items to another module with a matching list
Hi Could someone suggest a solution? screenshots attached also. I have a module (PER01) where I have these line items - the data is by employee (from employee list): - base salary - incentive scheme - other social costs I have another module (PER02), where I want the above data to fit in with only 1 line item called…
-
INV01 inventory ordering Foreast Demad line item.
Hi, In INV01 Inventory Ordering module I am getting the below value for forecast demand , where as in Training Material it is showing 2048. I have checked a couple of times of this value but not able to track the issue. Please let me know where I am going wrong here. Forecast demand value I am getting fromt this module…
-
Dimensionality
Hi, I would like to know what is the best approach for building when you have repeated Line Item's. How should you Dimension your Module? Attached is a screen shot of what I'm trying to replicate in Anaplan. Thank you
-
Applying Boolean formula from a time dimensioned to a non-time dimensioned model
Hiya, I have 2 modules: Meldaliste Sales - 2 flat lists, time System_Product_Filter - 2 flat lists The flat lists in both modules are the same. I need to create a boolean formula in System_Product_Filter that says if there is a blank cell in Meldaliste Sales then false else true. This formula isn't working because I have a…
-
L3 Sprint 2 : '5.5.1 Data Hub Model' File not downloadable
Hello, I am section 5.5 in L3 Sprint 2, where we are asked to - "In the Data Hub model, create an Employee Details system module. Then, download the Employee Details data file and import into the Data Hub module. " The file link doesn't give me a downloadable file. Can that please be shared here? Thanks! Richa
-
DAT02 PY Revenue to CY module
Hi, I am having trouble with the formula in the DAT02 PY Revenue to CY module. Steps I have performed thus far: 1. Pulled from the Historical Data in the Data Hub into the DAT01 module in the Sales Planning model (dimensioned by A1 Accounts, P2 Products and F19 Time Range) 2. Created DAT02 module in the Sales Planning…
-
Highlight Duplicate rows including first one
Hi All, I have a requirement to highlight rows with duplicate line items in a Module. I have tried using the ISFIRSTOCCURRENCE along with conditional formatting but was only able to highlight the 2nd duplicate row. I am using Concatenation to check duplicates within a unique key of 4 line items. Would be great if someone…
-
Parent child list to ragged hierarchy
Hi, I am looking for a way to automatically create a ragged hierarchy for all possible combinations. The input is a simple file with only the parent - child combinations. I've attached a screenshot of the parent child combination and how the ragged hierarchy should look like. I think it is possible to do this when I…