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)

       

      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

      sola.PNG