Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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