-
User stories
I am the beginner i want to know the information about user stories who will write user stories who will do testing on it and in the project how they implement the user stories
-
Data type mismatch: format other than LIST or DATE being referenced as a relation
any suggestion on how to resole above error
-
List parent in module along with time columns
Hi there, I would like to add a parent column for the list in my module. I want to create the following module which shows the list parent in the second column: At the moment I have the left and right side of the image as that part is a straightforward pivot: Page = volumes line item. Rows = Customer-SKU list, where…
-
Level 3 sprint 2 - How to populate G4T Territory>Account# list
I am stuck in G4T Territory>Account# list in Level 3 sprint 2. A2 Account>Product# list was similar to this one and we imported from data hub. It was clear for me. We assigned combined codes for the intersection cells in account-product matrix then imported it. In G4T Territory>Account# list is confusing. I couldn't figure…
-
need help for practice
Hi All I want to populate "text line item" which shows string between 1st and 2nd commas of the items in the module. How can i do it. which function should i use here Thank you & regards Yash
-
Manual Filter for a Hierarchy
Anaplanners, Had a table that displayed different layers of the hierarchy. Layer 4 rolling up to layer 3, layer 3 rolling up to layer 2 and so on. If i as a user select layer 4 then only layer 4 needs to be displayed in the table. I know there is a native anaplan functionality where we can select the hierarchy but we…
-
Optmizer issue - "Could not parse Optimizer configuration"
Dear experts, I'm trying to create an Optimizer, where I'm defining the Objective, Inputs and Variable. However, I get an error "Could not parse Optimizer configuration". Is it compulsory to define the constrain in it? Can you plz suggest what could have possibly gone wrong based on the error message. I tried to search any…
-
Level 3 Sprint 1 Story 7.3 unable to match the data
Hi I am trying to match With But no success. I mapped Segments directly from SYS02 any suggestions?
-
Creating ISBUDGETVERSION() similar to ISACTUALVERSION()
Please consider adding ISBUDGETVERSION() function, similar to ISACTUALVERSION(). This would eliminate having to setup another module with only Versions as the list and creating a boolean flag. All followed by IF VersionsControl.Budget THEN .... ELSE...
-
How to insert member in a list in between an order using actions?
I have several lists which are needed to be updated by users. So, I have created a module with a flat list (contains numbers 1,2,3.....100) and line items with these lists names. Created saved views with one column (i.e. List named line item) and imported this column data in the list. Added a "Run import" action button so…
-
13.3.4 Activity (Add formula to Profit and Loss Module) - understanding what these formulae mean
Hi I am working on the above activity, but struggles to understand what these formulae mean in the following format (If, then, else) with the sum function in the formulae: IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Medical Costs[SUM: 'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actual and…
-
level2 :Create DEM03 Demand Forecast Module
Hi I am trying to get the growth rate but adding 'DEM02 Volume Growth Rates by Week'.growth%(lookup:'SYS08 SKU Details'.Product Family) formula but the message is coming as invalid. I tried to lookup the SY08 product family as an intermediary module since dimensions are not same but still the message is showing invalid.…
-
Employee Expenses
Hi, I want to be sure in the Level 1 exam, the question is asked for FY even though the Employee Expenses are not based on time. So, since all Employee Expenses are given as currently values, the values for all FY are the same, is this normal? Thanks, Mark
-
Anaplan Live! Model Contributor Meet Up
Attending Anaplan Live next week, in San Jose? Make sure to swing by our Customer Connect meet up, specifically geared towards Model Contributors of all levels! Our own @rob_marshall will be leading a relaxed conversation and connecting attendees with similar backgrounds. Sign up today. Unable to join in-person? Make sure…
-
Ability to Add Multiple List Items on a Grid Card in Worksheets Additional Insights
Currently, there is ability to add multiple items in a worksheet main view: When there are grid cards in Additional Insights, the insert multiple items option is not available: The option to be able to add multiple list items without additional actions/processes is really helpful in addition to making the experience for…
-
Count in numbered list
Hello everyone, I am facing a problem in counting the same names in numbered list. Let me explain with pictures, I have a numbered list :- Style. In this list, every member has different code but multiple members has the same Display name property as shown in the picture below. I have a module "Module M1", where this list…
-
New Model Experience - Formula Editor Function Tool-Tip
To further enhance the modeling experience, particularly for new modelers, having a hovering tool tip when typing parameters within a function would be useful. It could be structured such that after typing the start of any function, a hovering display lists the required/optional parameters needed. As an example, typing…
-
2.4.7 Activity: Create Saved Views for UX
I have created a saved view as required for this activity but my work is markedly different from the example provided and i have not been able to figure out why. Here is my saved view as opposed to the example Example : My View: Here is how i set up the Pivot for the Saved view I want to view the Initial Demand Forecast…
-
Offset Formula Help
Hello, I am unsure what went wrong, but my Offset formula for FY20 is no longer populating. I had it working previously, but I don't know where I went wrong. I've been using the appropriate formula for calculating it and triple-checked the SYS01 it was pulling from. I was confused when my FY21 values weren't showing up in…
-
Finding blank cells in a number line item
I want to filter by a number line item to show just blank cells, but I cannot figure out how. I know the ISBLANK function is what I want to use, but it cannot be used on numbers. Is there a way to find blanks in a number formatted line item similar to the ISBLANK function?
-
Alternative for SUMPRODUCT
Hello Community, Is there any Alternative function as SUMPRODUCT()... If there any method please Suggest.... Thankyou In Advance. Regards, JeevaK
-
ITEM function cannot be used on composite lists with Summary of "Formula"
To reproduce: 1. Create a parent list and a composite child list. 2. Create a module with 1 line item with formula "ITEM(Child List)" and list formatted to "Child List". Applies To should be "Child List". 3. Change Summary to "Formula", the following error is shown: The formula for 'mod1'.'item1' is invalid: 'item1' =…
-
Count Filtered result
Hi everyone, I have two modules, let's say M1 and M2. In M1, the dimensions are Users and Activity (List of activities). In M2, the dimensions are Styles and Time. I have made a filtered (Style filter) which filters styles in M2 according to the selection made by the user in M1. If there is no selection made, M2 shows all…
-
Modeling in Anaplan with alternative tools: Part 2
Here at Anaplan, we are committed to creating a product and learning environment for everyone, which means providing tools, accessibility options, and knowledge for all people. We are fortunate to have a community of experts committed to the same, including Certified Master Anaplanner Mitch Aist (@maist1). We recently…
-
Ability to Turn Show Users Off at Line item level
If a line item is formatted on USERS, end user should not be able to see any other USER but himself in the dropdown and they should see only one name in the dropdown. Admins on the other hand should be able to see all. Hence the idea of Show Users: off at Line item level even if the module is not dimensioned by USERS. As…
-
L1 EXAM Q 6
Hi, Everything looks good but answer is wrong. Please help me
-
L1 exam
Hi, I am getting L1 exam now, can I skip to others questions? There is an option, Submit ! Thanks, Mark
-
Formula
Hi, I am following all steps but it doesn't work properly. where am i going wrong? Please guide me? Thanks, Mark
-
Disallow un-assigning items using the 'Assign' action
Description of the enhancement required: Disallow un-assigning items using the 'Assign' action. There's a left-arrow in the assign action that will delete an existing list item. It would be great to have an option to disable that arrow, or disable removing existing items this way. An example of the enhancement: Admins…
-
Assign Action that does not have the ability to remove the assignment
The assign action provides a great UX for a user to assign a list item to be the numbered list child of another list. In T&Q Use Cases, this can be used to assign accounts to reps. The downside of this action however, is that in the UI, there is a "<" that allows you to remove an account from the rep and thus from that…