List Expression Error

[Sandile_Mkhize]

Hi Community

I’m trying to create then sum a list of transport costs in the table called Accounts but the actual transport costs are sitting in another table called Transport Transactions

I tried this expression:
SUM(SELECT(Transporter Transactions[Cost],[Cost]"=>"0))

I got an error SELECT has invalid inputs

Please help!!
Thank you