Sum with condition

[Jqlik]

Hi everyone,

I need to sum the data from two columns, with the condition that the two colums are 'YES'.

For example:

Columna 1, columna 2, columna 3, columna 4

Yes, No, 100, 50

Yes,Yes, 20,10

No, Yes, 25, 50

In this example, i only would to sum the second row.

What would be the formula to calculate this.

Thank you.

[JonathanG]

try this

sum({<Columna1={"Yes"}, Columna2={"Yes"}>} columna3+columna4)