-
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…
-
Line item reference to a member from SUBlist
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? I have tried with the SELECT function, but I get an error because it is difficult to reference a member from the SUB list,…
-
Returns a date in the format date.
hi! Is there a function that returns each date in the format date? Or I would like to know how to implement it. Please help me！ idealized drawing:
-
Formula for a Line Item
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!
-
Different Timescale/Version View
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 as well. Versions: Actual, Forecast, Budget 20 Actual, 21 Budget, 21 Actual this should be in sequence as per the report.…
-
level 2 2.3.11.3
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
-
2.3.11.3 Create Line Chart Saved View
* 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
-
INCREMENTAL CALCULATION AND CONDITIONL FORMATTING
Hi guys, i need your help, im struggling with this, i will try to be as clear as possible . * i have this dashboard, column 2 is what i have now and column 3 i what im trying to achieve (i added the column 3 via excel). i would like to know if its possible to achieve the following setting in anaplan. the column 2 will be…
-
Aggregation Calc
Hi, Is there a formula in Anaplan applicable to this kind of aggregations calc? Thanks Jayden
-
Filter for report
Hi, I have a module with a list of products with different ages. I want an end user to be able to select whether from a list to show all products < 3 years, >= 3 years and >= 5 years. In my module, I have created booleans to check for each of the above. I have also created a list for the 3 periods. I'm a bit stuck now -…
-
New UX: Dynamic grid update based on filter settings
As a model builder I want to be able to setup a Grid which will be updated dynamically every time after a user wants to reselect any line item published as Field or Grid which are used as filters, but without the necessity of reloading the page. Current behaviour allows to have the same effect, but only if the User list is…
-
Level 2 Sprint 3 INV04 Percentage Full
Hi, I am am stuck with trying to figure out the Formula for 'INV04 Distribution Center Capacity'.'Percentage Full' Line item. I can't seem to understand what all to use in it since it says: Can anyone please help me understand the logic and figure out the formula! Thanks in advance!
-
Lookup a Numbered List to find contract that falls within Date From and Date To columns
I have a numbered list with different pricings with different validity time periods (Date From - Date To) in months. E.g., Item A #1 Price = 1000, Date From = Jan 21, Date To = Jun 21 #2 Price = 2000, Date From = Jul 21, Date To = Dec 21 I have another module with time period in months and price in rows/columns, as well as…
-
SELECT() For a list top level item
Hi All, I am trying to use SELECT to pull through the top level value so I can create a phasing profile to push a single value down a hierarchy. I thought this would be possible but I am getting an error saying that the reference is not recognised. How have others managed to achieve the same outcome?
-
Notification : How to restrict address?
Hi, I want to use Notification Function in UX. I want a function that Member can mail to Manager. There are a function can select recipients by module. So, I tried to use it and make this List and module. List: Manager List & Member List ListManagerMember XA B YC Mail Module (from Member to Manager) Appliers…
-
Payment cut-off
Hi, question please. How can I calculate the payment cut-off which is happening every week. I have created a system module, screenshot below. Scenarios of the payment cut-off. 1. first cut-off - day 1 to day 7 >>> payment is after 5 working days (example: July 1 to 7, 2021 then payment day is July 14, 2021 -excluding…
-
Monthly Cumulate
Hi Team, Is there a way for me to reset my cumulate on a monthly basis? Thanks, Elaine
-
OFFSET Value
I want to Offset values from dynamic day value. I hope the "Amount A" is offset to "Amount B like table. But the result was 0. 1/11/21/31/41/5Amount A 100200300 OFFSET 102 Amount B100300200 Result 00000 How can I solve this problem? When I use Monthly Offset Value, I could do it.