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