Hi, I've been digging around all the resources but could not find any solution to my problem. We are trying to build a legal hierarchy tree (ragged) with inputs into each entity in varying levels and …
Hi, Hope you all are having a good day so far. I would like to identify the least contract quantity falling within a price list range. if 10 contract quantities fall within a price range then I would …
@rob_marshall I am looking for some guidance on how to do weighted averages based on a selected amount of weeks? Our call center planning is in need of looking at weighted averages based on a variable…
Hi Guys, I need help in figuring out a workaround for Circular Reference. I recreated the modules the best I can and I hope its enough to understand. See below: This is the driver module and this is a…
I am trying to import Historical Weekly Data, but am constantly getting error. Please assist how to import Weekly Data? I tried several times, I have attached Screenshot.
Hi All, I'm taking our demand planners monthly forecast and converting it into daily then rolling it up into weekly buckets. I've successfully gotten us down to daily, using a fake timescale, added th…
I have a unique key list which is a standard naming convention of 12345_123456_123456. I would like to use a formula to identify the last 6 digits that are not 000000 or 0000002 and create a list subs…
Hi All, I have a module without time dimension,I am facing circular reference error here: Line items used are: Total = Sum (Lineitem1 + Lineitem2 +Lineitem3) I need previous cell value of Lineitem Tot…
Hi - I am trying to create a graph where it displays the number of items selected by the user. These items are marked through booleans. Is there a way where I can count how many items are selected per…
I have a numbered list, which has the same names (display names). These same name line items then have different child. The values of the same name list items needs to be added up to only one list it…
I have a list in which there are parent and child relationships defined. Ideally, these should have been created within a composite hierarchy but at this stage I am not considering redesigning the lis…
The standard excel format for Month-Year is MMM-YY. I.e. if a user types Jan 20, excel will convert this to a numeric value and display Jan-20. Anaplan does not recognise this as a valid time period w…
Hi,everyone. How do I get the last row number of a line item with characters entered? I would like to get row number "5" from this module. Could you tell me how to get the number? Best regards.
Hi Guys, I have been working on this formula for quite a while now, I hope you can give me an idea on how to do this. I will explain it as much as I can since I cannot provide a screenshot of the actu…
I am trying to write a simple formula and Anaplan keeps removing the parentheses which causing an issue with the order of operations needed. What am I missing here? Do I have to break out both parts i…
I am busy with the level 2 training and hit a small hick-up I build a few modules referring to the P3 SKU list and worked fine until yesterday. This morning i get this message: But if i look at the li…
Hi Guys, I just want to ask help on the formula. I was able to create a formula and got the values but the succeeding time does not show no values. This is what it looks like in excel I also included …
Hi everyone, I would like to get the value from the list using FINDITEM, using a Property other than CODE. I don't have to use FINDITEM. I woud like to know if there is an alternative. sample... I wou…
Hi Members, I am adding formulas to the properties, I am thrown this error. The actual output (mentioned as output in pic) is shown. Please assist me with the correction, that needs to be done. Regard…
Hi, I am having problems with what I think should be a fairly simple calculation but I'm not sure what I'm doing wrong. I have a debt value. Interest is calculated on that debt value. Every 6 months, …
Hi All, I have module which has no time dimension and with 3 line item Bond, Sale, Total Calculations are as below Bond = total (When i right this formula its throws circular reference error) Total = …
Hi all, I have a dashboard for forecasting and I want to allow users to copy from one quarter to another quarter, using breakback (at a quarter level instead of monthly level). For some reason, whenev…
Hi All, Can you please help me in populating the attached years by formula , where I am not using Timescale in the module and my Mapping Year (line item) format is Year. CHRT** and YR** are my two dim…
Similar to improving imports with time periods (Idea Link), it would be great if the FINDITEM() formula was tweaked when working with Time, to make the formula return time periods for strings like Jan…
Hi everyone, I have two module. I want to post values from a module that does not have a date dimension to a module that has a date dimension. Also, there are two target Line Items. The mounting image…
I am having trouble interpreting Anapedia's Time Aggregation functionality which states that: X = YEARVALUE(Y) * Seasonality% Will allocate Y according to a seasonality percentage (not shown). I have …
Hi Team, I need an help in using '^' operator(in excel) into anaplan, while looking through all available operators and constants I could not find this operator. Is there any alternate function for th…
Dear Friends, I have some products and each territory allocation. I want my final module to look like M-1 I have attached .csv file (P1) for reference Regards, S K
Hi, We are a NZ Telecommunications company. We have the need to report metrics such as ARPU $ (avg revenue per user) and Avg cost per user across our segments. I can do this compared to our forecasts …
