Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this experssion// Sum({<Year=,Month=>}Wait) // I need to add if status= cancelled give 0 with previous one
Hello,
Not clear with the question. Could you please elaborate 2nd part of the question a bit more ?
Thanks,
Ashutosh
with this expression ------Sum({<Year=,Month=>}Wait)
I want to add another condition ----if STATUS='Cancelled' give 0
Hello,
Something like this ?
If (Status = "Cancelled", 0 , Sum({<Year=,Month=>}Wait)
)
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
Hello,
In which chart you are trying to put this expression ?
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;
I try to add also at extract but its not work