How to obtain an average with some conditions.

[#1]

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

[swuehl · Accepted solution]

Hi kramelot,

you could try something like

=avg( if( isnull([DI Father]),[Time to Response]))

or use any other condition to check that DI Father is "empty" ( equals zero, compare to '' etc.)

Regards,

Stefan

[#3]

Thanks a lot.

I use your suggestion Avg(if(len([ID del Incidente Padre])=0,[Tiempo de Atención])) and it works.

Thanks