3 Replies Latest reply: Jul 14, 2017 2:32 AM by Arvind Patil RSS

    isnull for only types

    sony sing

      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)




      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