-
Mapping
Dear All, I have one use case in which I am confused to get the output. Below is the use case: I have almost 10 lists (A,B,C,D etc.) and each list have almost 4-5 list items (A1,A2,A3,etc.). Now the end user will have the access that he can select the list items from each list (single/multiple). Once user has selected few…
-
function
can someone elaborate when to use sum , lookup and select in easy to understand way. i have read it from anapedia but still struggling
-
Search Text in a String
Hello Community, I am looking for a function to find a character(s) within a string, similar to CONTAINS function. For example, I need to find the word Ananplan in the string "I love Anaplan". Is there a function for this? If yes it will be really helpful if you can share. Thank you, Yogesh
-
Allow semi colon as a delimiter for emails as this is the default in outlook
As a user I should not have to configure Outlook to use commas as a delimiter for sending to multiple recipients as this option is not checked by default. The MAILTO function in Anaplan only accepts commas as separators for multiple email addresses. It would be useful if it also accepted semicolons.
-
Cumulative SUM for Top Ten Items
Hi There, I was wondering if you can point me in the right direction on finding how to do the below 😃 I am trying to build a report that can show me just the Vendor that make the 70% of the Total Expense. I have 3 dimensions (VEndor LIST, Cost Center and Product). As a Line items I have the "Expense" and "% of Expense".…
-
sum values
Hi guys, please help. attached a pic. Is it possible to sum up "values" this way, to have the result in "values months" column? - january : values from january - february : values from january and february - March : values from january and february and March .... - December : values from the past 11 months + december. I…
-
Get the Month from a Switchover W/e Date
Hello all, How can I get the month where the switchover week-end falls under? I've tried several things, not getting the desired output, yet. Thanks!
-
How to link parsed list back to List codes
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 company code, A's being account code, and the D's being department code. I now want to have another module that references…
-
Statistical Forecasting algorithms into a user specific model
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 along with the hierarchy and the calculation formulae for different line items, I prefer to have that developed everything from…
-
Summary Methods Based On Line Items - Product as an example or Weighted totals
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 on a model I have been building recently, many of the summaries require the product of 2 line items divided by the total of…
-
Circular Reference help
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. Pic Formula IF 'Actual 30+ Dollars from Tableau' = 0 AND 'Actual 30+ Dollars from Tableau'[LOOKUP: 's54 MonthonBook…
-
Get Native version name to a lineitem
Hi, Is there a way i can get native version to a lineitem in text format ? Similar to using name(item(List)). Regards, Tom
-
Inventory/Cost From Prior Periods Question
Current business model: Have monthly beginning Inventory + beginning inventory $ value (+ production/-usage) calculating ending inventory lbs. & $. Ex: July beginning Inventory 100K lbs. & $100K value. (-usage of 50K lbs/$) leaves ending inventory for July and Beginning Inventory for August at $50K/ 50K lbs. Business…
-
Referencing same line item of prev row
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 Calendar month of prev row + 1 Has anyone faced similar issue? The Else part of the formula gives circular reference.
-
Lineitem Format : Timeperiod show Quarter and Year
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
-
Previous for a monthly result only.
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 3 - 2 Feb 28 - using Previous I will get 2 The previous will only get monthly result and will reset next month? Thanks in…
-
Calculation to get Quarters for Previous Year Only, Current Year Only, and Forecast Year Only etc
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 be achieved? Thanks.
-
Filtering on user - Data is incorrect
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 relevant employees. But problem is total ,say total salary is not as per selected country ,it will be of all employees from…
-
Dynamic Aggregation
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 want to have this cell (time period: Apr 18, list period: Aug 19) to show sum of transaction period Jan 19 - Jul 19 for time…
-
Removing '0' from 3rd place
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.g- PROJECT NAME: PR120 then new calculation field should remove '0' in the 3rd place what can be the syntax to remove or…
-
Time: PREVIOUS vs ITEM(TIME) - 1
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. In the example above it is probably straightforward "yes" to ITEM(TIME) - 1 approach. But what about when there is some…
-
Calculation to get Quarters for Previous Year Only, Current Year Only, and Forecast Year Only etc
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 be achieved? Thanks.
-
SUM or IF? Performance and Readability
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 international retailer. This retailer is setting up stores in different countries. When setting up a store in the first month,…
-
Retrieving last non-zero value
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 to set up a formula that retrieve the last non-zero value for FY20 and FY21 for instance. Thank you for your help!
-
Removing line items in List
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 Total. I want to delete only Total (Parent). Internal Workings I) Having around 180 modules using the H1/H2 list as a…
-
Lookup between two modules with different dimensions
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% in module DAT06 to show up in module CAL04 per the "reference period #" line item (e.g any "month 0" cell with have…
-
Parent to child Levels
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 : Dimension : L0 Cost Center I created two line items below in my target module but when i try to get the data from the source…
-
Level 2 Sprint 3 INV01 Inventory Ordering
@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 with this formula? 2. Safety stock Target = WEEKVALUE('DAT04 Distribution Center Parameters'.Weekly Safety Stock) Safety Stock…
-
Formula Box Auto-Resizing/Docking/Undocking
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 undocking and redocking so that the window has an auto-sizing feature when you toss it to the edges of your screen or…
-
MAILTO Functionality Character Limit
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 scenario the line item picks up more than a certain number wherein the character size of the line item exceeds the…