Calculated field for Sum(),Group by

Good day,

I want to add a calculated field for total received Qty against the job in multiple receipts. So i tried Sum() function in calculated field, but i got following error.

I am new to the SubQueries…I just want to know ,if there are 7 tables in my 1st subquery(main BAQ), do i need to add all those 7 tables ? also how i call add Sum() function to rcvdtl.passedqty and where it will be ? In subquery1 or newly added subquery2 ?

Any help will be greatly appreciated.

That group by should not be there. It’s a checkbox in display fields.