-
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…
-
Performance Comparison - YEARVALUE(x) vs x[LOOKUP: FY]
Hi all, Was hoping to get some insight into the performance implications of obtaining the year value of a line using either YEARVALUE(x) or x[LOOKUP: FY]. Both will retrieve the same result assuming summaries/timescales are setup correctly, but they are definitely not calculated the same (based on anecdotal tests). From…
-
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…
-
2.4.4.1 Update DEM03 Demand Forecast Module
Hi, for level 2 (2.4.4.1) I know the formula for the baseline forecast is the following. However, would someone be able to go through the intuition behind this with me? My original formula was much more simple and it made more sense, but it was way off. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03…
-
Time Function
How can I pull quarter values (Q1,Q2,Q3,Q4) from Expected Invoice Date ? The module has no time scale applicable. NOTE: Time Settings doesn't have quarter totals enabled .
-
Conditional Formatting on LISS
Hello, I created a module that has a lot of line items and corresponding values in 3 Versions (FCST, Budget, Variance). I need to mark the Variance column in red when the Variance has minus value for a subsequent line items. PS. Variance is part of LISS from source module Can you please suggest me what I should do in this…
-
Copy dates between List items
Hi, I have three line items: Actual , R1, R2. Actual has data from Jan to Dec. I want to copy Actual data into R1 from Jan to March and April to Dec empty for input data. I want to copy Actual data into R2 from Jan to Sep and Oct to Dec emtpty for input data. This action starts my budget. It would be great to start this…
-
Users List-Workspace Admin
Hey guys, Got a query, i have a module with Users and Business Line and boolean line item which enables each user to a business unit. I published the same on a page but users without workspace admin are unable to view the users list, is there a way to make it enabled for them ? Or a workaround for this issue ? Thanks
-
Level 2, Sprint 3, Product Replenishment UX Page
Hi, On my UX page with the first 2 checkboxes selected (Jan 20, Feb 20) and FY20 in the page selector, i expected to see only those two time periods. However, i am seeing FY21 data. I'm thinking I've goofed something up in my SYS00 or SYS01 filters - could anyone offer some guidance on how i can troubleshoot this? Thanks…
-
Count Duplicates Based on Text Field
Hello! I'm running into a problem that I'm struggling to solve and was hoping that I could get some help here. I have a numbered list that represents employees. Sometimes, employees are converted from part-time to full-time and when this happens, they are assigned a new employee ID. I need to be able to identify cases…
-
Level 2 Sprint 3 - Safety Stock Flag Count
Season's greetings all. I don't know why I am wrestling with this formula as it seems straight forward but it does not appear to be working correctly. My line item formula is as follows; 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] Is there a logic context error here…