Straight table not displaying negative time value

[peterderrington]

Hi, 

I have a straight table that displays the smallest value of a given field (expression= "Min({<Ward={'NSEC08'}>}[Difference between bed reserved time and PAS time left])" ) which seems to work fine apart from when it comes across a negative value (due to people incorrectly entering the right values). 

Is there anyway to just either blank the value or at least identify it with a minus sign.

Thanks, 
Peter

[peterderrington · Accepted solution]

Its ok, i worked it out.

I used this expression and it now shows the first true minimum value:

Min({<Ward={'NSEC08'},[Difference between bed reserved time and PAS time left]={">00:00:00"}>}[Difference between bed reserved time and PAS time left])