-
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".…
-
User Story 1.6 Module
Hello, I just built a module for User Story 1.6 and wanted to make sure I am on the right track before I proceed to User Story 1.7. The validation criteria for the story is, "I will know this is complete when I can see the Final Account Sales Targets aggregated for each country’s small, medium and large segments." Any…
-
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…
-
Skills and Drills
I am putting together a list of Anaplan Skills/Drills as part of our Enablement program. Asking for your suggestions. What should make the list and at which modeler level (MB, SA, MA, etc)
-
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!
-
Allocating the 53rd week to a different year
Hi All, Is it possible to allocate the 53rd week in a 445 arrangement to a different year? Example; from FY20 to FY19 and from FY25 to FY24
-
Level 2 Training - Sprint 3 - INV01 Inventory Ordering Module
Hello, I am not sure what is wrong here: * Beginning Inventory Formula: IF 'SYS01 Time Settings By Week'.'Not 1st Week of Timescale?' = TRUE THEN PREVIOUS (Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory[LOOKUP: 'SYS08 SKU Details'.Distribution Center]----Does this not look correct? Any help is…
-
Rolling data snapshots of Weekly and Monthly forecast for different Versions
We have a scenario where there is a need to do a weekly forecast for short term (next 13 weeks) and monthly forecast for remaining periods of the fiscal year. The forecast and actuals need to be captured in both weekly view and monthly view. Also the monthly view needs to be tied to a consolidation system (another tool…
-
All Periods amount not updating when time range updated for module
Hi I have created Module A previously with timeframe FY19 to FY22: The total of a line item for FY19 to FY22 is 36. The total of this line item for FY20 to FY22 is 29. As regards, the "All Periods" amount: Module A shows a total of 36 when I set the time frame for that particular module to "FY19 to FY22", as expected. But…
-
optimization
hi In production optimization formula given for C3: Constraints i have written as it is given in dashboard but still it shows erroe when run optimiser. i I have attached screenshot of the error and formula written for c3: constraints. Please guide
-
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
-
Level 2 - Sprint 1 Activity 1.3.6.4 Create Import Distribution Center Details Saved View
Hi, * Module Name: SYS07 Location Details * Saved View Name: Import Distribution Center Details * Filter to show only Distribution Centers Select SHOW for the Default Shipping Method line item and save the view. How to Filter to show only Distribution Centers means? I just added filter to it but no values appeared.
-
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…
-
How to delete a subset?
Hi, I accidentally created a subset under a wrong list. In activity 1.3.7.4 Create s G3 Location: Distribution Center? List Subset I was supposed to create subset under Try It Hierarchies but I accidentally created under Location Flat, now I'm not able to delete it since it is referenced in 'DAT01 Beginning Inventory'…
-
Summing the time dimension
Hi, I'm trying to do something which I think should be very simple but which I just can't seem to get working in Anaplan. I have two modules with exactly the same dimensions, except one has a time dimension (years) and the other does not. How can I have a line item from the second module (without the time dimension)…
-
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
-
Need help on 7.2.3 Activity: Import Data into Employee Details Module
-
Report design question
In the attached screen shot you will see one of our report by Project and by Time. This module is dimensioned by Time, Project List, Function list and Funding type. We have data for actual, forecast and etc. We need to see Project ID and Project Status information on this report. But if I add them as line item, they show…
-
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.
-
Level2
Level 2 Completion I have completed and passed all the exams of Level 1 and could some one let me know web link for Level2 exam and required information. Thanks Narasimha
-
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…
-
How to delete imported data?
i want to know how i can delete imported data
-
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,…