-
Referencing List Items in Formula
I have module D03 that shows how many slots each product family uses. D03 is dimensioned by Time on rows, and PR2 Product Family list and 1 line item 'Slots' on columns. I am trying to write a formula that 1. references data from another module, and 2. does some calculations for all the data in each item for PR2 Product…
-
Can module 'Applies To' have multiple lists from the same hierarchy?
I have created Line Item subsets and certain modules for filters for other modules. My ultimate goal is to assign different line items to different list items (across the hierarchy as well). I have P1 Product Lines, P2 Product Families, and P3 Product Names. I have module D07 which shows how many slots each of P2 Family…
-
Model Architecture and reporting stages in anapalan
i am learner i want to know that the Architecture and reporting stages in anaplan, i was totally balnked seen this questions. help me out on this.
-
Looking up Day of the Week list for a LI in a different module
Hi, I'm trying to be able to look up a total for all the individual days of the week from my historical data. i.e, I would need to look up all the Mondays in the Month of July and sum them together. I have weekdays as a list but I'm getting a error message when I try to use LOOKUP, SELECT, or SUM. Please advise. Blue Print…
-
Architecture of the model stand alone model using ALM?
Hi I am learner till i have faced issue questions in panel Architecture of ur model and what is the meaning of stand alone model. based on that stand alone how can u use ALM by steps. Another one query about reporting(stages) and permission staging. it will be helpful further to improve my skills.
-
haschildren(List)
There should be a haschildren() function that takes in a list that a module is dimensioned by and returns a boolean, indicating whether or not the list member has a child. This would be especially useful in conditional formatting with multiple dimensions, where for one of the dimensions, you do not want the conditional…
-
10.2.6 Activity: Add Formulas to Employee Expenses Module
Hello, Anyone Can help me to figure out the error in Bonus, not sure where I am mistaking it. I tried both way Copy and Paste the formula also written it. However, still have having same issue. Please find the attached screenshots. Thanks.
-
Have a line item that does not apply to a dimension, not repeat itself
Hi guys, I am wondering if there is a way to have line items that do not apply to a specific dimension, not repeat itself within a dimension. I have a list that has another module storing details about the list and then another module which has the time dimension look at revenue for specific accounts. I have pulled through…
-
The values doesn't appear in Gridview
I use the same formula to calculate a value in a line item, it works in one module (Sales Qty - Motor) but it doesn't work in other modules (Sales Qty - Mobil and Sales Qty - Truck). I use different subsets from the same list for each module. Blueprint of Module 'Sales Qty - Motor' Gridview of 'Sales Qty - Motor' I use a…
-
DAT01 Level 3
Hello, Can someone explain me in which step I need to create the DAT01 module, I started few weeks ago level 3 and now I'm stuck at 4.6.5 Level 3- User story 3 where I need to create DAT02 module, but the first one is missing from my model. Thank you!
-
Model Building Level 1 Model Building Activity 6 8 1
I thought I followed the steps properly, but my finished product looks like this but, according to the solution, it's supposed to list the regions in columns to the right of code. Can someone please help me understand what's missing?
-
how to import model to model without ALM
i am new learner of anaplan please explain how import model to model without alm
-
10.2.2 Import Data into Non Employee Expenses Module
hey guys what date format do you do I am at my wits end lol HELPPP
-
Which filter will have most optimized result?
Hi @MarkWarren and Anaplan Experts, Is there performance impact on filtering in below scenarios (assuming its a complicated filtering logic)? Question1:The Boolean Filter line item is a subsidiary view in a module. If this is applied does it work slower than say a Filter line item which I move to different module to remove…
-
Is there a function that checks the name of a list item in a module and returns specific data?
Hello, I am trying to build a UX dashboard that displays data from two different modules. In D01 Slots (PAGES: Version, Locations, Resource Groups, and Teams. COLUMNS: Time. ROWS: Product Names and one line item "Slots"). Module D01 allows me to see the number of slots each product uses. In D02 (PAGES: Version, Locations,…
-
Anaplan model building level 1 virtual class
Can anyone update me on when the Anaplan model building level 1 virtual class will start?
-
INV01
INV01
-
Formula Calculation
I am writing calculation formula which I am struggle a little, hoping anyone can help me out. When writing calculation formula in Excel, we can use ( ) to group the calculation together, but Anaplan does not work the same way or am I work? Is there a way to group calculation together within Anaplan? Thanks in advance,
-
Hide rows with zeros in UX
I have a UX grid, which has a couple of dimensions. Depending on what selections they make using the selectors the grid can show rows with zeros in all columns. How can I automatically hide rows with zeros? I don't think I can link to a boolean with a formula like 'Show = Actuals <> 0' because the selection can change (if…
-
Version
Hello Community, I have one module with version as dimension. In resultant module no version dimension is used How it is possible to flow value to resultant module..... Thankyou In advance Regards, JEEVAK
-
Level 3 Sprint 2 : Assign Action
Hello, I am trying to set up the Assign action with filter by Country & Segment. I have the two list formatted properties in the G4T Territory>Account# list, but I'm not getting any option to select these while setting up the Assign action. Can someone help me understand what am I missing here? Thanks! Richa
-
Trying to look up a LI for the previous 6 month average
Hi, I'm trying to look up a LI for the previous 6 months average using a TIMESUM. The formula is working but no numbers are appearing. Not sure why the numbers are not appearing. The formula is below. Thank you
-
Activity 3.3.5.1 Create Inventory Ordering Module - 0 as shipping time
Hi, I am having issues with getting the correct values for Shipping Time Weeks in INV01 Inventory ordering model. The formula used for this is 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] and that should be correct I think. See below screenshot for…
-
Not getting same values in rep04
Can anyone help having issue in getting different value in rep04
-
Anaplan Map Chart of India
Hello Team, Anaplan map chart is very useful display for the users however it's restricted to only few countries in Anaplan. Currently I have few Indian Clients who are actively looking for India map chart. Do we have anything in the pipeline for the same? If not, I would suggest we include that in future release, it will…
-
Activity 3.3.5.1 Create Inventory Ordering Module - multiple issues
I am having multiple issues with the formulas in the Inventory Ordering Module. First of all, I don't understand why I Have 0 as Beginning inventory for Nutzo Bar_En with the formula IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning…
-
What is the major difference between Anaplan connect and actions
I want to know the main difference between using of anaplan connect and actions. What is different between production list and production data. Please give me the information.it will be helpful for me.
-
Option to hide Parent/Summary item in dropdown list
We should have the option to hide the Parent/Summary item when used as dropdown list. Sometimes end users don't prefer to see this as they cannot select these items in the dropdowns list... And this confuses them.
-
What is the best function on the below use case: TimeSum or MovingSum ? (For best performance)
Hi, Generally it is suggested to use the TimeSum function if my target is not dimensioned by time. If my target is dimensioned by time, it is better to use MovingSum. But MovingSum doesn't allow start period parameter other than the number data type. What can we do if my target is dimensioned by time and my start period…
-
Mapping Module no time dimension to time
Hello, I have a csv import that is not dimensioned by time and date in the same cell. It can not be changed for a monthly process import. I am 90% of the way there. I created an import module (not dimensioned by time) and a reporting module that is dimensioned by time. I am able to pull in the data to the reporting module…