how to you write a calculated column for SUMIFS for 2 column criteria in spotfire

[eddy ng]

in excel i would write

sumifs(sum of column, criteria range, criteria 1,criteria range, criteria 2) Etc.

What i want looks like this (in excel)

Sumifs(Total Duration column, equipment column, equipment ID, Reason name column, Reason ID, Shift Date column, date)

how do i do this in Spotfire

the columns tables are attached.

 

 

long description:

Sum of Delay if, (

Equipment ID = (793F, 793C)

AND reason name = (X, Y, Z etc)

)

Per shift Date.

[Manoj Singh]

In Spotfire: Sum(If [Column Name] test condition,101)

Example: Sum(If [Column Name] >= 10,101)