Need Avg for Each

[soniasweety]

Hi all,

I want to calculate count and avg hrs of each type of numbers  to particular .

attached excel with sample example.

can anyone suggest the way?

only some of the Type values to be shown.

Thanks

Sony.

[sunny_talwar]

May be this

Avg({<Type = {'Order'}>} TimeHrs)

[dberkesacn]

After you implemented Sunny's great solution I suggest to read this blog.

Average – Which average?

[soniasweety]

Hi Sunny,

thanks for simple exp;   but I don't want to show in type dimesion and for that also count I dnt want to see in the straight table what is the possibility?

like below screen shot I need only    order and server only.  avg and count rest I dnt want to see

whatever I am showing avg for that only I want to show count and dimesion values.

[sunny_talwar · Accepted solution]

May be this

Avg({<Type = {'Order', 'Server'}>} TimeHrs)

and

Count({<Type = {'Order', 'Server'}>} TimeHrs)

[soniasweety]

Yeah sunny its  working

[soniasweety]

Hi sunny,

I want to show one of field is null for that type values only how to write this exp?

=only( if(IsNull(Assigned), Number))    in this I need to include   'Order', 'Server'

[soniasweety]

Hi,

Andrey Khoronenko

any suggesitions

[tomovangel]

I think what you want to see can be done in a text box object , in the description write your expression like this :

=Count({<Type = {'Order', 'Server'}>} TimeHrs)

-Angel

[sunny_talwar]

May be like this

=Only({<Type = {'Order', 'Server'}>} If(IsNull(Assigned), Number))