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

Pages: 1 2 3 4

Leave a comment