Hi all,
I am struggling to know (with my limited knowledge) on the best way to achieve the below calculations so that I can see the total quantities and costs of ITEMS but also be able to filter these results to view them based on certain criteria.
Table A has ITEMS and cost per item
Table B has COMPONENTS (a single ITEM plus variables (eg wastage %))
Table C has ASSEMBLIES (made up of several COMPONENTS)
Table D has TAKEOFFS (measurements)
Table E has TYPES
TABLE F has LOCATIONS (various locations, each with one TYPE)
An ITEM has many COMPONENTS
A COMPONENT has an ITEM
A COMPONENT has an ASSEMBLY
An ASSEMBLY has many COMPONENTS
A TAKEOFF has an ASSEMBLY
An ASSEMBLY has many TAKEOFFS
A TAKEOFF has a TYPE
A TYPE has many TAKEOFFS
A Location has a TYPE
A Type has many LOCATIONS
What I want to achieve is to take variables from ITEMS, COMPONENTS, ASSEMBLIES & TAKEOFFS, and calculate quantities and costs of ITEMS.
Note: If the results were flattened into individual rows, the result would be approximately 24k records
Any advice on how to achieve this would be greatly appreciatedโฆ.
LinkedIn
Twitter
