-
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
-
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…
-
How Nested Formula affect performance
Hi, I want to improve modele performance. I'm trying to improve IF statement. Here is two statement. Answer1 : IF A THEN IF B THEN 100 ELSE 50 ELSE 0 Answer2 : IF A AND B THEN 100 ELSE IF A AND NOT B THEN 50 ELSE 0 The performance of Answer2 is always better than Answer1? --- Another nested Formula affect performance? This…
-
Pull values from one module to another module
Hello All, Consider 2 General List List 1 Has A,B,C,D,E,F List 2 Has A,B,C,D,E,F And 2 module in which module 1 have dimension List 1 has value A=100, B=200. C=300, D=400, E=500, F=600 And module 2 have dimension list 2 I want to pull values of module 1 to module 2 how it is done... other than lookup Thankyou In advance…
-
Update the Summary Method Setting
In Level-1 under "8.8.4 Activity: Add Formulas to Size, Margin Report Module" why do we need to change the Margin % line item Summary Method setting to Formula. What is the outcome or output of this change? Is that a major impact on output?
-
How to calculate the 50th percentile
Hello, Do you know how to calculate the 50th percentile (or any percentile) in Anaplan? Thanks! Arnaud
-
Level 2 Sprint 3 INV01- Beginning Inventory Calculation Not Working
Hi, I am sure I am using correct formula for calculating Beginning Inventory but my module doesnt seem to reflect that. Formula - IF 'SYS01 Time Settings By Week'.'Not 1st week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory. But output for first month is coming 0 since…
-
REV03 Margin Calculation Module
Hi, When I check the REV03 Margin Calculation Module in Level 1 Course, I see that Cost of Sales is greater than Revenue in almost all cases after Jan 20. Maybe I am doing something wrong but I think this is not normal. Can you double check them for me? Thanks, Mark
-
2.4.7.1 Conditional formatting
I have added the conditional formatting for Final Forecast, but not sure what to do for Initial Demand Forecast to make it look like the material provided screenshot. Here is the rule I have in place currently My other question is if it is okay that I do not have any data like the material shows for FY21?
-
2.4.11 Creating Roles
I am stuck on creating the roles and which access to provide to make the dashboards visible. Will the dashboards not show if they were made on My Pages?
-
Dependent Dropdown Not Available
I'm trying to setup a dependent dropdown for a line item that is a in list format where the list is a numbered hierarchy (mid-hierarchy). When I select my hierarchy level from the list, the checkbox for dependent is grayed out (all filter checkboxes are unavailable). Help!
-
Map multiple list member to single member
How can we map multiple list members of different fiscal year to single list member fiscal year. Both the line items are in same format
-
Modules for Dashboards
Hi, I have a question about best practices for setting up Modules for Dashboards. Currently we have LI's from different modules that we would like to display on one Dashboard. Is it best practices to create a Output module for a Dashboard and that will have all the different LI's in one place from those different modules?…
-
How to Compare Text of One Module to Another Module with Different Dimensions
Hello, I have 2 modules, each is using a different dimension (numbered list). Both modules have a line item which is a text. On the 3rd module that I'm trying to create, which is going to have the same dimension the same as either of the preceding 2 modules, I need to retrieve the text line items from both of the 2…
-
How to Create Reporting Version
Hi, I'd like to see how I can create (2 different) reporting versions; a mid month ROF (rolling operating forecast) version and a end of month ROF.
-
How to Define the current week in anaplan
Hi, Is there a possible way to define the current week in anaplan and current week should change automatically. without updating the cycle
-
Nested Ifs for Commission Calculation
Hello i would like to set a basic if nested formula for estimating let's say commissions . If my limits are in units : 0-300 commission 0.2 301-500 commission 0.25 700 and above commission 0.30 Whats the correct syntax : (if Units Sold>=700,0.30,if(Units Sold>=500,0.25,if(Units Sold>=300,then 0.2,"Zero"))) whats the…
-
Average Of Flat List
Hello All, Is it possible to find average of flat list. If it is possible please help me with it. Thankyou in Advance Regards, JeevaK