BusinessObjects Board

CountIF

Hello,

I hope there is a solution for my Problem.
I want to count all Values that are grater than 0 and not empty.

I tried this but they din’t work.

=Sum(If (IsNumber()) Then 1 Else 0) → #IERR

= Where > 0 → Syntax Error (DMB0007)

Why does this work but if I want to check a Number not???
= Where (=“Solved/Completed on first call”)

Thanks for any help

Daniel :wah:


dhartung :de: (BOB member since 2004-11-08)

Moving to BusObj Classic forum. If this is not the correct product forum, let us know and it will be moved accordingly.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Try this:

=Sum(If Not IsNull() Then If > 0 Then 1 Else 0)


Mahi (BOB member since 2004-07-22)

Regarding

Take a look at this Reporter FAQ entry.


Andreas :de: (BOB member since 2002-06-20)