List Expression Error

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

Hi! Welcome to the community!

So, I’m not sure where you got the syntax for the operator used in the filter criteria but your SELECT should look like this:

SUM(SELECT(Transporter Transactions[Cost], [Cost] >= 0))

NOTE: The “=” is not necessary for a SUM since it adds nothing to the result. If this was the AVERAGE() function it would make a difference.

1 Like