-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
my resultthe lesson result
-
Look up for future periods
Hello, What's the formula for looking up only future periods? In our module Professional Services Forecasting, I have actuals up to and including current period and blue inputs for forecast / future periods. We then have a module that groups various job codes called Professional Services Profitability. This already splits…
-
Stacked charts with several dimensions UX App
I published a post on the Anaplan Community concerning the problem I'm facing on an App Anaplan, and I've been told to post an idea regarding my problem, so here's the problem I would like to solve: I want to create a chart from a module that has several line items and dimensions: -Dimensions are: Time, and a List composed…
-
12.4.4 Activity: Create Saved View for Profit & Loss Report
the result displays the actual version whereas it should show only the budget and forecast version the lesson reslutmy result
-
Data from Line Item Subset back to original line item
Hi, How can i get back the data from Line item subset back to the original line item? I used the LIS as my dropdown to another module and i want to consolidate back the data from the dropdown to my main module. Thanks, Tom
-
Regarding 80000 Character Limit in Mailto function.
Hi, Can anyone please clarify whether spaces and newlines are counted as a character in the 80000 character limit in browser? Thanks and regards, Aakash Sachdeva
-
Filter References
Hello all! In the modules screen within settings, you can view whether a given module is shown on a dashboard AND which other modules reference that module. This gives a great indication whether or not that module is active OR whether it is a candidate for getting deleted. What is NOT shown, however, is if a given module…
-
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…