Formula in list or module
Hi, Background I’ve a CSV file, 300K to 400K lines, with 3 fields, “Salesperson”, “OrderID” and “OrderAmt”. This file is loaded into a list, “List_Orders”, which in turn drives a module “Module_Orders”. “Module_Orders” is 2-dimensional, with “List_Orders” in the columns field and line items in the rows field. It’s used to filter orders for different countries, through saved views based on a calculated field, “Country”. The different views are then exported to other lists for further processing through actions. The list and module structures are as below: [img height="231" width="780"]https://us.v-cdn.net/6037036/post-image/kCmn6jH.jpg[/img] [img height="144" width="780"]https://us.v-cdn.net/6037036/post-image/EtyfJ1i.jpg[/img] There are 2 calculated fields, “Country” and “Actual_OrderAmt”, and they are calculated in the list. The “Module_Orders” module only contain links to refer to the “List_Orders”. Issues It takes a long time for “List_Orders” to be updated from the CSV file. The actions to export views are also time-consuming. Questions [list=1]
- The 2 calculated fields are created in the list. Will processing be faster if the calculated fields are created in the module instead? As a general rule of thumb, will it be better for formulae to be placed in list or modules? [list=1]
- Will processing be faster if “List_Orders” is “copy-pasted” or imported directly into “Module_Orders”, instead of “Module_Orders” using links to refer to “List_Orders”? I know Excel goes faster with paste-values instead of links, not sure if Anaplan works in the same way too.