-
Best Practices for creating a formula dealing with SELECT
Hi, We are trying to create a formula that will subtract the sum of all the List Items, (excluding List Item 'Other'), from the overall Total of all the List Item totals added together. We were thinking of using the SELECT function to pull in the amounts for each List Items and then summing those all together in a SYS…
-
DEMO 03 Demand Forecast. Weeks(All week issues)
why all weeks are visible to me for 2020 . Rather than 4 Weeks ??? Thanks & Regards
-
Ratio of what % each child makes up of parent
Hello, I am attempting to calculate the % of a parent forecast each child makes up in a given time period. For example, a month has a 100 unit forecast in America. Texas makes up 60 units and California makes up 40 units (both children of America in a list). I am trying to show this: Texas 60% California 40% America 100% I…
-
New Model Experience: Not able to fully view formula bar when model is deployed
Hello, while I can open the formula bar in an ALM Dev model - I cannot do the same on any Test Environment (or the live environment). This is making very difficult to debug any issues on a deployed enviroment (need to check the formula in Dev which might have already changed) by another developer. Not too sure if this is…
-
Most used Planning Models in an Organization
Hi Anaplan, @JaredDolich @Misbah @rob_marshall @MelanieM What are the most used Anaplan Planning models across different sectors, especially in the following domains: 1. Financial Planning and Analysis 2. Sales & Operations Planning So, will try to learn more about the same for execution. Thanks & Regards Badam
-
3 months average of historical sales the year before
Hi, I need to calculate the three months average based on the historical sales data the year before. For ex: Jan 20 Feb 20 Mar 20 - Average values should go under Jan 21. 100,0,100 - 66.7 Jan 21 value Please could you suggest the optimal solution for the same? I have attached the screenshots for reference
-
Level 2 - Sprint 2 : Activity 2.3.9.2 Update Historic Volumes for Baseline Forecast
Hi, In this activity my formula is IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 . My result is 0, I don't know whether it is right or wrong. Can somebody please confirm this. Attaching the screenshot. Thank You very much.
-
Formula help on counting a Text LI
Hi, Need help on how to count the number of times a Text dimension LI shows up under a List LI. We have tried to use the SUM function as well as LOOKUP function, but they did not work. For Ex) We would want to know how many "Merchant Id's" are under each individual 'Legal Milestone" Below are snap shots of the two line…
-
add child to certain list members
Hi guys, i have a module dimensionned by a list, this module is published in the new ux as a worksheet with an action button that enters data. what im trying to ask is: is there a way to achieve this (pic) ? i have a flat list, parent hierachy = total.
-
SUM with Group Number
Hi I want to sum Orders with Group Number. The point is Group Lineitem is not formatted List, is Number Formatted. 1-Nov2-Nov3-Nov4-Nov5-Nov6-Nov・・・Group123123 Order100200300400500600 Odrer(Sum)500700900500700900 I tried Rankcumulate or Sum Functions, But I can't Solve this.
-
Filtering/Formula based Complexity
Anaplanners, Had a query that i have been stuck on: - I have a module dimensioned by Projects, a List with serial numbers 1-10, list formatted Line item (Project Phase). Ask is, Projects dimensioned as row headers, Serial Numbers 1-10 as columns, Project phase/ Line Item as selector. End User can select a particular phase…
-
Level 2, Sprint 3- 3.3.6 Activity: Test the Shipping Cost Formulas
Hi, I am struggling with updating the formulas of Confirmed PO Delivery and Confirmed Purchase order receipt. Regarding "Confirmed PO Delivery", I understand to replace OFFSET by POST, to push the data to future periods instead of pulling: POST(PO Submitted, -Final Shipping Time Weeks, 0). But I don't get what is wrong…
-
Level 2 Activity 1.3.4.2
I'm unsure of where I am going wrong. The task here is to populate the missing Regions columns with the parent line item from the 'Countries' file. I am mapping the following; column 2: country name to Target: Country Flat column 3: Parent to Target: SYS06 Country Details Line Items Perhaps, i'm not understanding the…
-
How to find no of strings in a concatenated string
Hi Everyone, I have line items which is the concatenated string ex - 123,435,234,678,567,987 I would like to find no of strings present ie 6 Could you please help me with this. Thanks Tejaswini
-
Level 2 Sprint 2 2.3.10-Baseline Forecast for FY21
Hi, I checked the answers related to this topic but I couldn't find the answers. In the DEM03 Demand Forecast module, I have the Baseline forecast values for FY20 which is coming DAT03 Historic Volumes module. However, I don't have baseline forecast values for FY21. I tried to write if/else formula for it but it didn't…
-
Using List Properties
Hi All, Why is it best practice to avoid using list properties? As a central location to hold all the data relevant to that list that does not require the user to update it seems like a perfect option. I am referring to properties such as all items of the hierarchy and permanent mappings that will never change. My question…
-
Selective Access
Hello, My model consists of hierarchical lists, E1 Expense category, E2 Expenses. I created an input module with E2 expenses, time(months), Money spent (line item) as dimensions. I have applied filters such that user shall select E1 expense category(in user filters module) and input module shows E2 expenses of selected E1…
-
How to get Formula to display the time it is pulling
Hi, Need to know how to get a date to show for a line item that is dimensioned by time, but the module is not dimensioned by time. The formula is working correctly, but can only see the result in a subsidiary view. Need to know if possible how to get the result to show when the LI is not in subsidiary view. If this is not…
-
Polaris Engine and Calculation Memory Consumption
Exciting news on the new calculation engine. I saw the memory consumption on data https://help.anaplan.com/616ee341-8a5f-4718-8c90-c82e34eca86c-Understand-sparsity-and-density , however how do calculations compare in consumption of memory? There is a 3x usage for data, but if I increase my number of cells, how does this…
-
Multi-Dimensional Scatter Plot Alternatives?
Hi all, Bit of a complex one here. The application use case is calculating the Minimum Variance Efficient Portfolio for those familiar with Finance / Portfolio Management. The Anaplan question to be solved in simple terms, is how can I combine these two charts to display as two different "lines" within the same chart (in…
-
Manage List Subset in Module
Hi, I want to use List Subset. We can import Boolean item to List Subset. But we can not input the formula in List Subset and can not make a refference in module. How can I manage it in module and List? And Can we filter original List by List Subset?
-
Using Boolean Field to Filter
Hi. Currently the Retention (B8) field is returning the sum of all values. I've introduced a boolean field but i'm unsure how to update the formula so that it only returns the value we want (which is always the most recently added). There maybe a smarter way to achieve this?
-
Formula Help
Hi, Currently I'm trying to make it so if a end user puts in a number from a inputs model I created, then it will override whatever is there in the current month. The formula below is what I created so far but need help getting the input to override whatever was there for that current month. Formula IF End User…
-
select
when we should use select function . can anybody tell me with an example or scenario .
-
Decimal control for multi currency
Gurus, In some line item, currency will be different and depends on company to be selected. For example, if subsidiary is Japanese company, currency will be JPY which is no decimal point, And if subsidiary is US companym currency will be USD with 2 decimal points. So, how these are managed in Anaplan? In case of…
-
Help with Formula LI 'Currently Optimized Through'
Hi, I'm trying to create a formula that will pick up the first day when the LI 'Y02 Accounts (Forecast)'.'Closing Balance (01)' is less than 1 million in the forecasting days. The formula below is what I created. It is not pulling in a date. Formula IF 'Y02 Accounts (Forecast)'.'Closing Balance (01)' < 1100000 AND 'S01…
-
Nithyashree_ Level 2 sprint 3 exams attempts
Nithyashree nithyashree@matasma.com. Hi, I have taken two attempts in the level 2 sprint 3 exams. And all the other attempts are loaded with the same score as in the second attempt. Suggest me any ideas please and also suggest to me is there any possibility for another attempt. Thanks and Regards Nithyashree.
-
time formula to show the first 1 -5 weeks of the beginning of a time period in SYS01
Hi! Is there a boolean line item to add to SYS01 so it only shows the first 1-5 weeks in the SYS01 module? it's annoying to see 100 weeks when all I need to see is 10 or so
-
Idea Exchange item that deserves some attention! Please support!
Hello fellow Anaplanners! I have a scenario that is captured exactly in the following Idea Exchange and I'm certain you all have or will need this in the future!! The scenario is essentially to have a line item summary method that is a formula and is DIFFERENT than the formula of the line item. Add a custom formula for…
-
L2 3.3.5 Wrong result INV 01 for begining inventory and shiping time weeks
Hello, can you help me for find mistakes: 1. Begining inventory 2. And wrong result for shipping time weeks = 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product] Here is my results: I can't find misstakes. Everything seems correct. Thank you.
