-
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.
-
XOR for versions
The lack of summary for versions made me create this formula: I am trying to get a functionality to have a boolean checkbox which will be FALSE for all other versions, but the one I have selected for the same time period, else - all TRUE. Time periods have this "All periods" summary which can be used in SELECT. Do you guys…
-
Best Practices for FINDITEM on blanks [PLANUAL]
I was going through the PLANUAL and noticed this error. I think the formula is wrong. If majority items in a list are blank then it should be: * IF ISBLANK(Line Item) THEN BLANK ELSE FINDITEM(List, line item) Also, is it efficient to use ISBLANK() in conjunction with FINDITEM() OR a better approach could be using a…
-
Calenday Days
Hi, For your assistance please. How can I mimic the calendar in anaplan? my time period is Days but I need to get the specific weekdays equivalent (Monday to Sunday). I created a list of Monday to Sunday and just have a drop down list...how can I do it automatically in the formula? Thank you.
-
Dynamic locking of editing data in the model
Hello, I need to make the ability to lock data for read and edit. I have done it using two line item read/write and then 'Driver Permission' inside module. However, this only locks the top level of the hierarchy - L2. I need to block also the ability to edit for the lower level of the hierarchy (L3) depending on whether…
-
INV01 Line Item Formulas
Hi, Would like to know if my Line Items are correct. Please advice The Line Items are on the attached pic. Thank you
-
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2
Region importing issue at 1.3.4.3 Update SYS07 Location Details Module LEVEL 2 While importing the location.csv into the SYS07 Location Details module, the region part is not uploaded properly. why? because: It is the reason that region flat has 3 line items: AMER, EMEA, APAC. However the csv DATA file attributes the…
-
Showing selected version in a line item
Hi all, is it possible to show the selected version as a line item in that module? For e.g., I have 3 versions in version settings and have a module with these versions as a dimension: Actual Version 1 Version 2 Can I create a line item that automatically shows which version has been selected? So the line item should…
-
Erlang A
From a callcenter planning perspective we currently have Erlang B and Erlang C, which allow customers to compute the SLA given an amount of calls and their staffing level. The industry is starting to look more at the amount of calls answered as a percentage of total calls (TCA) as a way to determine staffing. In order to…
-
Pull the data from child list to parent list
Hello Community, I have the next list named BOM Lvl 1 List, with a Total Price Column, But, I need that if Semi-finish are TRUE, go to the list named BOM Lvl 2 List, and pull the price, adding up the price of the children: Thanks!
-
Count number of parent for Unstructured List
Hi Team, I am trying hard to calculate the number of parents for individual list items for unstructured list items. Kindly let me know in case of an optimized formula IF NAME(PARENT(ITEM(Region_Group))) = "All Regions" THEN 1 ELSE IF NAME(PARENT(PARENT(ITEM(Region_Group)))) = "All Regions" THEN 2 ELSE IF…
-
Workflow process approval
Hi, question please. I am doing a workflow process approval that once the preparer/inputter submitted to the approver the input cell will automatically locked. Is it possible that the input cells will not be locked to the approver side once the preparer submitted it, which means that approver can edit the numbers in the…
-
Variance - calculation
Hello, I have created a module with multiple line items and values for FCST and Budget. I need to calculate the Variance which has a different formula for each line item. What is the best way to do this?
-
Cumulative interest calculation
Hi, I need to calculate total loan interest for each month, and every loan was originated in different month. See below example, five loans were originated in different months and amount, and they have same interest % for each life period( i.e. loan x period 1 interest % is 1.058%, loan y period 1 interest % is also…