I need to add if status= cancelled give 0

[Sam_1985]

I have this experssion// Sum({<Year=,Month=>}Wait) // I need to add if status= cancelled give 0 with previous one

[AshutoshBhumkar]

Hello,

Not clear with the question. Could you please elaborate 2nd part of the question a bit more ?

Thanks,

Ashutosh

[Sam_1985]

with this expression ------Sum({<Year=,Month=>}Wait)

I want  to add another condition ----if STATUS='Cancelled' give 0 

[AshutoshBhumkar]

Hello,

Something like this ?

If (Status = "Cancelled", 0 , Sum({<Year=,Month=>}Wait)

)

[Sam_1985]

I try this one its not working 

If (Status = "Cancelled", 0 , Sum({<Year=,Month=>}Wait)

)

then I change If to Aggr its  appear ok no wrong at expression  but no result also

[AshutoshBhumkar]

Hello,

In which chart you are trying to put this expression ?

[Sam_1985]

in table inside the expression of one column named Wait which

I write calculation at extract 

If(STATUS = 'Done', Date(SURGERY_DATE,'MM/DD/YYYY')-Date(CREATED_TIME,'MM/DD/YYYY'),
If(STATUS = 'Pending' and flag = 1,Today()-Date(floor(CREATED_TIME,'MM/DD/YYYY')),
Date(BOOKING_DATE,'MM/DD/YYYY')-Date(CREATED_TIME,'MM/DD/YYYY')
)) as Wait; 

[Sam_1985]

I try to add also at extract but its not work