1 Reply Latest reply: Jan 3, 2013 9:18 AM by Jonathan Brough RSS

    Extract Numbers under and over null

      Hello again,

       

      I have a colum with different numbers over and under null.

       

      Savings
      2
      -2
      3
      0
      -5

       

      1. I would have only the numbers over null, how can i extract

      2. How Can i extract the numbers under null?

       

      After that I will make a summ over the Saving with 1. over null and 2. under null.

       

      Could anybody help me.

       

      Thanks.

        • Re: Extract Numbers under and over null
          Jonathan Brough

          Not sure about over and under Null as Null doesn't exist, but over and under 0 can be found summarised with these fields:

           

          TableName:

          LOAD

            Savings,

            if(Savings>0,Savings) AS OverSavings,

            if(Savings<0,Savings) AS UnderSavings,

            if(Savings>0,1) AS OverCount,

            if(Savings<0,1) AS UnderCount,

          FROM. ... TableSource;

           

          Should be able to do Sum(OverCount) and Sum(UnderCount) in a chart.

          Jonathan