Hi, I've created a module that contains a list with data that has 3 components of a list concatenated (to limit the number of rows). The list data looks like this: CCCC_AAAAAA_DDD - with the C's being…
Hi - I am new to Anaplan and I have a quick question: Let's presume we are to develop a supply chain demand planning module for a client. Since we exactly know what all lists/line items are needed alo…
Hi All, I feel that the summary methods in Anaplan could be improved further by including more flexible options to use other line items (same dimensionality) to influence summary method. For example o…
Hi, The following formula below is giving me a Circular Reference when it should not be. Please advise on how to avoid this error. The LI that this Formula is in is Acutal and Projected 30 + $ Curve. …
Hi, I am facing issue in trying to reference the same item of prev row. For example, This is the Excel formula for a line item ‘Calendar Month’ : IF Calendar month of prev row = 12 THEN 1 ELSE Calenda…
Hi, Is there a way I can show in my line item formatted as Time range to show both quarter and year ? The reason is to have a full year view of my data. Regards, Tom
Hi Team, Is there a way I can use Previous but won't affect my previous or succeeding month? Example: Jan 1 - 1 Jan 31 - using Previous I will get 1 Feb 1 - 0 (should not get my result in Jan 31) Feb …
Hello, I'm trying to configure the view below using the Time Settings and/or Time Lookups module. I've tried multiple things, but haven't been successful. Can anyone provide guidance on how this can b…
Hi , I have a module with list of employees who belongs to different countries .I have created a user filter on country selection . Now when user selects a country ,the list of employees shows the rel…
Hi, I have a module below, a list (transaction date) on the rows and time period on the columns. Is there a way to do dynamic aggregation vertically based the list transaction date? For example, I wan…
I want to create a new filed and a logic where the input will be project name which is a combination of letter and and digits. The new input field should replace '0' in the 3rd place of the project. E…
Hi all, What's your opinion, should I ever use PREVIOUS(ITEM(TIME)) function when ITEM(TIME) - 1 does the same thing? Best Practice says it's not recomended to use PREVIOUS() due to low performance. I…
Hello, I'm trying to configure the view below using the Time Settings and/or Time Lookups module. I've tried multiple things, but haven't been successful. Can anyone provide guidance on how this can b…
I'm interested to see which is the better performer and also, subjectively, which function is more 'readable': SUM or IF, in the following scenario... Consider that you are building a model for an int…
Hi, I created a module with exchange rates data for each month. Then, I put summary as : sum, time: closing balance. But as I only have data until Sep 2020, it puts 0 for FY20 and 21. So, I would like…
Hi All, Need help with how the process to follow the deletion of line items in the List. H1/H2 is the List within that we have 3 line items called Total(Parent), H1 and H2(Children) it's summing up to…
Hi, I have below two modules: Module CAL04: Page: Business Line, Line Items, Column: Time, Row: Transaction month Module DAT06: Page: Business Line, Column: Periods, Row: Line Item I want to have NCO%…
Hi, For your assistance please. I would like to ask how can i lookup child which is on level 2 and the parent is on level 0? Hierarchy Target Module : Dimension : L2 cost center Source Module : Dimens…
@Misbah 1. Shipping Costs = Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] Is there any problem wit…
Having the flexibility to have the formula bar in the new modeling experience expended at the top versus jump to the bottom. In addition having the ability to move the formula bar around similarly to …
Guys, I have this issue with the mailto functionality, wherein I am picking up user names for "TO" from the line item 'To', which is formula driven and is picking up more than 1 user. In a particular …
Hello, I have a line item in my model - X with a list format. This line item uses the SUB list (as format). In another line item - Y I need to refer to a specific member from X , how should I do this?…
Hi All, I'm having trouble figuring out the formula for this. I need to create a Formula for "A" for the succeeding months but the first month should be an input. Thanks!
Hello All, I would like to create a reporting module as follows (in the screenshot). Is it possible to have a view like the screenshot attached? Please note I have versions in the model and timescale …
Saved View Name: Line Chart * Chart should show monthly Baseline Forecast and Initial Demand Forecast for two years. Hi Can anyone help me how can we set time for two years here is my work
* Chart should show monthly Baseline Forecast and Initial Demand Forecast for two years Hi How can we set the time for the next two years can anyone help please here is my work
