2 Replies Latest reply: Sep 6, 2011 3:15 PM by kramelot RSS

    How to obtain an average with some conditions.

      Hi Everybody...

       

      I want to make a graphic that shows the report average time, for this i must to establish some rules to obtain the rigth value, i got three fields, the first is call "DI", the second is call "DI Father", and the third one is call "Time to Response";  in this moment i am using the next to obtain the value

       

      Avg([Time to Response])

       

      But i need that only calculate the average time where the field "DI Father" is empty.

       

      How can i do that?.

       

      Sorry for my english.

       

      Besr Regards