Counting a value where value is a positive/negative number

[#1]

Hey Guys,

Wondering if anyone can help. I am trying to create an expression if possible that is a sum of a field in my table loaded. But if possible i only want to count 1 in the value in the table is positive. I have both positive and negative numbers in my table.

I thought it might be as simple as:

if(num1 > 0,NumericCount(num1),0)

Any help is much appreciated, Thanks.

[wallinpeter]

I would create new field in script.

Add to new column to table....

if (value>0,1,value) as NewValue

create expression....

sum(NewValue)

[Anonymous · Accepted solution]

sum(if(Field>0,1,0))

[fred_s]

Hi David,

Maybe this one?

See attachment

[#5]

got it guys thanks.

sum(if(ARR_DELAY>0,1,0))