Extract Numbers under and over null

[#1]

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.

[Anonymous · Accepted solution]

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