-
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…
-
SUM by Quarter
I want to sum the milestone values by each quarter in a different module(Line item). NOTE: Quarter period(Line item format)in Quarter line item is from time scale and not model calendar. Source Module has three dimensions: Target module where sum of milestone values need to be calculated has two dimensions: NOTE: Neither…
-
2.4.6.1 Create AD01 P3 by Account by Week Module
Is this correct? I followed the directions and wrote the formula into the AD01 P3 module as indicated (screenshot below). However, I am not getting the square check boxes in the DEM03 Demand Forecast module. I did a select the correct item under the write access driver column within the DEM03 Demand Forecast module
-
Convert Text to Date Time format
Hi All, I have a simple one to ask. Source system is sending a date value which contains both date and time and it is storing in Anaplan Text line item in a module. Need to convert this text to date format and post this need to convert it again into IST or other time zone format. Kindly help here. Example: Source date…
-
Level 2 - 2.3.8.4 Activity
I used the following formula to return the monthly value to weeks; MONTHVALUE('DEM01 Volume Growth Rates'.Growth %). I would have assumed that the monthly figure would be divided by 4 for each of the weeks. However, it is reflecting the same monthly value across all of the weeks. Maybe i'm missing the intuition behind…