SUM returns negative value
Hi,
I need to count how many items in the report have a particular string.
I'm using:
[SUM(<frxDBdataset."Confez"> = 'Pronto')]
The result is correct (35), but is negative!
eg -35.
How can it happen?
thanx
miyomo
I need to count how many items in the report have a particular string.
I'm using:
[SUM(<frxDBdataset."Confez"> = 'Pronto')]
The result is correct (35), but is negative!
eg -35.
How can it happen?
thanx
miyomo
Comments
use count function
see the user manual on aggregate functions.
of the band where the datafield originally appears.
ie
[SUM(<Customers."Country">= 'US',Band4)]