Which field type I need?

[soriano]

I have a calculation field (dif) in this field some results to be in negative an anothers in positive.

How can I count all the positive number and all the negative numbers??

[dspires]

Create a summary calculation field and set to count.

[shierkev]

You could do this (although it involves using 2 more fields)

Create one calculation fields.

calc Field 1 =If(Fieldwithnumbers > 0, "1", "")

The sum of this field will be equal to the number of those with values greater than zero

The difference between a record count on the found set and this total will be the negative numbers.

second calc field would be

calc field two = status (currentfoundcount) - sum(calcfield 1)

This would be all records not over 0

Alternatively, you could do a second field the same as the first one

calc field two =IF(fieldwithnumbers < 0, "1","")

a sum of this field will give you the number of records less than zero.

Use the second method if some of your records contain no values at all and you don't want them counted as negative.

Kevin

[soriano]

Thanks Kevin for your help,

It's working

God Bless you

[Vaughan]

The Sign() function does this in one step.

[soriano]

I need for separate, if i use a summary with count, this field count all (positive & negative) I need cout all the positive in some field and all the negative in another.

Anyway Thanks for your help.