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

[WillowMobileSys]

Sandile_Mkhize:

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

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.

help.appsheet.com

SELECT()

Gather column values from row in table or slice