-
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…
-
Using a IF THEN ELSE formula and LOOKUP formula to solve a Customer Buying Group mapping question
Hi there My organisation's Anaplan model was originally built to cater for a "Bottom Up" sales plan , and I am amending it to also cater for a "Top Down" sales plan, when required. We have 2 modules in this model, TOP DOWN and TOTAL SALES. TOP DOWN - Only has one Customer Buying Group code called "TDB" - short for Top Down…
-
SUM Lineitems by Weekday
I want to calculate the amount by Weekday. This is the image. Module A ListDay2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/72021/1/8LineItemWeekdayMonTueWedThuFriSatSunMonLineItemAmountA100 10 50 Module B ListWeekdayMonTueWedThuFriSatSunLineItemAmountB150(100+50) 10 I tried this formula but the Monday Total has…
-
Level 2- Sprint 3-INV04 Distribution Center Capacity
Could someone help me with the formulas for these line items. 1.Distribution Center Capacity 2. Percentage full
-
Getting Sum of Line Item's Previous Values without Time Dimension
Hi Everyone, I'm trying to find a way for the following challenge: 1. There is a standard business case model for a supermarket that includes such lines as CAPEX, Revenue, Expenses, etc. The standard business case model doesn't have a specific launch month or data of launch for a supermarket as this is a business case for…
-
How to calculate the turnover rate?
Hi, I have a question about calculating the turnover rate. To calculate it, I use this formula. Formula: IF Inventory <= 0 THEN 0 ELSE IF Inventory <= MOVINGSUM(Demand, 1, 1) THEN 1 ELSE IF Inventory <= MOVINGSUM(Demand, 1, 2) THEN 2 ELSE IF Inventory <= MOVINGSUM(Demand, 1, 3) THEN 3・・・・ But this formula continues forever…
-
How to use FIRSTNONBLANK/LASTNONBLANK in a custom calendar
Hello everyone. I have created a custom calendar. I have mapped Week(List) and Year(List) corresponding to Time(Days). I would like to create a module that sets the start and end dates to the Week(List) and Year(List). I thought I could use the FIRSTNONBLANK and LASTNONBLANK function to get those dates, but it does not…
-
Adding of column values
Hi, I have a column which is made up from a List. I've created a "new column" called "Sales and Marketing" and would like to sum up the values that are currently in "Sales" and "Marketing" respectively. The values in the other columns remain as it is. Is there a formula that is able to do this? Structure of the module as…
-
INVO1 SHIPPING TIME(WEEKS)
Hi, I am getting an error putting this formula to the shipping time(weeks). 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP:'SYS07 Distribution Center Details'.Default Shipping] error:Dimension of mapping used for lookup doesn't match any dimension of the result can…
-
3.5.4.2 Activity - Beginning Inventory Figures
The beginning inventory in this exercise seems off. I even checked other comments on the board and I have followed what I could. the second screenshot shows the set up for the INV01 Module for the beginning inventory line item. The formula is correct. but maybe something to do with the summary set up ?
-
Remove ability to edit Formula column on Line Items in Blueprint Mode
I've always been told as best practice to not edit formulas for line items directly in the formula column of blueprint view, instead to click on the line item and then activate the formula bar on the top of the page. However, we recently had a new model builder, who had not yet heard about this best practice, copy and…
-
Combing 2 input values under one column
Hi, I would like to add up the 2 input values from "Sales" and "Marketing" into the new column called "Sales and Marketing". The reason is because there has been a change in the categories of business and the previously separated "Sales" and "Marketing" are now combined as one single category "Sales and Marketing". Is…
-
Copying Same Data Line Item to other Formulated Line Item
Dear All, I have a scenario as follows : I have a Module with SKU, Company as dimensions. Sales Volume is an input. List Items in Company are GST, TMB, BCC. Now, I want the data in line items to be copied to the company as follows: The output module should contain the input value as well as the copied data value. Thanks,…
-
Create a report view based on its criteria
Hi Everyone, I have a question on how to do a linkage between 3 modules (Source Module, Mapping and Target) The image below is my mapping, basically, each Lane is connected to each Slottage Type based on each column. eg: if a lane is AA1AO "SC In - Consortium" should appear in the line item "Chartered In Exp - Initial…
-
Collect() function results zero values - why?
Hello, I used collect() function to take data from the source module. I created LISS from the source module and then used as dimension in the target module. The dimension are the same in the both module, unfortunately I see zero values after using collect(). Can you help me understand why? Thank you. Best regards, Dominika
-
Post transaction after 2 working days
Hi Community, I need a help to post transaction after 2 working days. I have a daily collection amount as a line item in a input module. I want to post these daily collection amount in a calculation module after two working days. For e.g. Monday, 1 March 2021 collection amount will be posted on Wednesday, 3 March 2021 and…
-
3.3.6 Activity: Test the Shipping Cost Formulas
Hi, I am trying to update the confirm purchase order receipt formula with a POST function. I believe I am again, not understanding the intuition behind this. can you please guide me in the right direction? IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, 1) ELSE 0
-
Data format change from List to Text
Hi We have two columns in a General list ,i.e SKU Config Group and Config Group. The SKU Config Group is having format type of List and the Config Group is in text format. Our requirment is to copy the value from SKU Config Group column into Config Group. The reason being there are formulas already buit in the modules…