Adding the Stock Value Rollup
Repeat the above to add another Rollup column to the Manufacturer table:
- Display name: Stock Value
- Data type: Currency
- Behavior: Rollup

Click Save and edit again to launch the editor for the Rollup field, to be completed as follows:
- Source: Manufacturer
- Related: Vehicles (Manufacturer)
- Filters
- Sale Date does not contain data
- Status equals “Active”
- Aggregation
- SUM of Purchase Price


Leave a comment