Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sony,
Use below code in Dimension:
If(Wildmatch(Type,'Order', 'Server'),Type)
Thanks,
Arvind patil
thank you Patil. it is working
Hi Sony,
Please mark It .
Thanks
Arvind Patil