Extract Numbers under and over null

Thu, 03 Jan 2013 14:02:46 GMT

Hello again,

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

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

Anonymous — Thu, 03 Jan 2013 14:18:59 GMT

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