Couting negative values

[#1]

Hello,

I need to develop a bar chart in which I will count only the amount of negative values in one of the selected dimensions in my database project.

Could anyone help me about the expression I should use for that?

Thanks,

Andre.

[its_anandrjs]

Hi,

You need to count some thing like in your expression for negative values

=Count ( If(YourField < 0, YourField ))

As i understand or not please confirm me.

Anand

[swuehl]

I believe you need an if() in there:

= count(if(YourField <0,YourField))

to count the amount of values (use sum() to sum them up)

Stefan