-
2.3.11.3 Create Line Chart Saved View - how to build a chart view
Hello, I would like to ask how what is needed in the last task with line chart in this training. I have built a chart, but do not understand how to save it in the view I published it to the dashboard, but it is not the saved view I guess. Please, help. Thanks in advance, Anton
-
9.2.6
I got most of the formulas to convert and are fine but the unit price growth and unit cost growth are both giving me errors.
-
7.2.4
The formulas are giving me a strange error. Please help
-
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…
-
Intermittent Anaplan Interface Error Message
Hello, Former Anaplan Support member here. I was just about to create a Support Ticket for this intermittent error message, I wanted to see if there were others who have run into this message before? 1) I am checking to see if other users are facing this issue. 2) This is not model or workspace specific. I have already…
-
Filtering text and numbers (NaN) in same module
Hi there, I have one module(saved view) which is the basis for an export to another system. This saved view consist of number and text (format), the export in the other system blocks when one of the number returns a NaN. Therefore we need to exclude these NaN. We thought we found a solution by creating a Line Item List…
-
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