4 Replies Latest reply: May 30, 2014 5:47 PM by Eduardo Sommer RSS

    Not return 0 values

    Jennie Elliott

      How would I write this expression so that it will only show values that are greater than 0?

       

       

      (Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))

       

        • Re: Not return 0 values
          Eduardo Sommer

          Try

           

          if((Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))> 0,

          (Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand)))


          if the result is 0 or less, the expression will return a null value


          Eduardo

          • Re: Not return 0 values
            Prem Kumar Thangallapally

            hi there try  this

             

            (Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}*{'=(Sum({$<PARTS|SubTypeDesc-={'NATIONAL ACCOUNTS PART', 'NATIONAL ACCOUNTS BATTERY', 'NET STATE'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))>0'}, PARTS|ActiveFlag={1}>}PARTS|OnHandInv)=0, Null(), (PARTS|OnHandInv-PARTS|Obligated-PARTS|KeepOnHand))

            • Re: Not return 0 values
              Jennie Elliott

              Clarifiying, I need it to only display results that are postive or negative and NOT 0.