isnull for only types

[soniasweety]

Hi all,

addition to this Need Avg for Each

I need to include particular values in  the expression which I am using is

only(if(isnull(Assigned), Number))     it is givning all the values which is null.. but I need for only two which I mentioned for other expression like below

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

and

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

I need :   only(if(isnull(Assigned), Number))         this is giving order and server , solaris also  but  I need the result  as  order and server only

[arvind_patil]

Hi Sony,

Use below code in Dimension:

If(Wildmatch(Type,'Order', 'Server'),Type)

Thanks,

Arvind patil

[soniasweety]

thank you Patil.  it is working

[arvind_patil]

Hi Sony,

Please mark It .

Thanks

Arvind Patil