Is it possible to sum the contents of a parent table with the contents of the child table?

I've been building a working project application using a number of parent and child tables.

Some of the parent views carry rate card values for specific services and these are displayed within the child view when selected. There are ad hoc services in the child table with free currency fields for varying prices.

Is it possible to create a calculated field to sum the total the free currency fields, with the rate card parent fields to autogenerate a total order value per project?

I've tried to use some excel formulas sumproduct & sumif but these are not supported - any advice would be appreciated.

Michael Leneghan shared this idea · Jul 14, 2022