I want to know if there is a possibilty for checking the test colum on their status and only do the calcuation of the same animals if all status are finished. Is there also an other approach for cheking the if all status of each animal is finished ?
the result is a statement which takes only the animals into account which have on all level the status finished for their test. For these animals I only want to calculate the duration. For the moment the statement takes all the rows into account which have a value in the the colum. So if only in one row like in the above example is a date in the last row the whole animals will be taken into account. This needs to be changed
