Problem in Sums

[JP-AN]

Hi, i wonder what i am doing wrong with the next formula.
What i am trying to do is to sum prices (Importe) of the rows where PAGO = "Red" or "Yellow" condition.
But i am receiving this error message in this formula 
SUM (SELECT (MOVIMIENTOS[IMPORTE], ([PAGO]="Red", [PAGO]="Yellow")))

[diogolupcosta]

SUM (SELECT (MOVIMIENTOS[IMPORTE], AND(([PAGO]="Red", [PAGO]="Yellow"))))]

You missed the AND()

[JP-AN]

Hi thanks for your reply, i am getting the same error message, 
"The expression is valid but its result type 'Price' is not one of the expected types: Yes/No"
SUM (SELECT (MOVIMIENTOS[IMPORTE], AND(([PAGO]="Red"), ([PAGO]="Yellow"))))

EDIT: i tried this solution (https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Select-Function-Error/m-p/434762) with the ANY function but i am getting a SUM error.

[JP-AN]

I foud out that i dont have to put that formula in the Slice Condition. Instead i create a Virtual Column in the table Movimientos wich is goes like this:

SUM(SELECT (MOVIMIENTOS[IMPORTE], OR(([PAGO]="Red"), ([PAGO]="Yellow"))))

And it worked! many thanks for your help with the formula!