-
Creating a running sequence of numbers in Anaplan
Hi, Am wondering if there's a way to create a running sequence of numbers in Anaplan. Am trying to create a sequence of numbers that run from 1 to N in columns such that 1 is in col 1, 2 in col 2 ... N in col N. Reason am doing this is to see if there is a way to copy a certain cell value (say a number) from the left most…
-
ANAPLAN level 1 , level 2 and ANAPLAN way
Could someone explain why a fee of $1500 is being charged when there is open course available as in the first attachment by the organization
-
How to enter the time in a line item?
hi! I want to make a module to know the elapsed time. But I don't know how to enter the time in the line item. Please let me know if there is a good way. I want to make it look like this.
-
9.2.5
The formulas are giving me a weird error message
-
10.2.6
I am having trouble with one formula and I am not sure how to fix.
-
User input by monthly and yearly
Hi, Do we have any work around for, User input for forecast version by months and budget versions by yearly, Below is the ss attached.
-
Level 3: Sprint 1 User story 1.3
Dear Team, In User Story 1.3 in Model Build Specification, it was asked to create a DAT05 model in the data hub. But DH Model does not have TR, Do we need to create a TR or I am missing something? @Misbah
-
calculate values from modules with different dimensions but with same ancestor list
Hi, This is my first post so I hope the example will be clear. I have a ‘Customer Hierarchy’ list and a ‘Product hierarchy’ list. Both lists have the same parent hierarchies (see print screen 1 below) Now I have a Sales module with the customer hierarchy as dimension and 2 line items (sales volume, product) The product…
-
6.10.2
When I try to add a formula to SYS07 it gives an error. check photo
-
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…
-
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…
-
Formula Question
Hi, I'm trying to create a formula that will pull values in accordance to each weekday. Below is the Formula I'm currently using. I have screen shots of the Modules I'm pulling from as well. If you need more information on the topic please let me know. 'D01 Funding Ratios'.Average of Fund * '01S03 Weekday count by…
-
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…