Count an expression

[#1]

Good day.

My english isnt good, so I'll try to explain. I have a percentage value, you get what expression of the average current year divided by the average last year , this percentage gives me result in a negative or positive value.

I need to know how I could count how many of these results are negative or positive.

For example:

(100/150) -1 = -0.33

(175/200)-1 = -0.12

(225/125)-1 = 0.8

Header 1	Header 2	Header 3	Header 4
A	100	150	-33%
B	175	200	-12%
C	225	125	80%

To count the result would be one positive and 2 negative.

How I make this count of a calculated expression ???

[anbu1984]

Positive count expr: Count(If([Header 2] > [Header 3],1)

Negative count expr: Count(If([Header 2] < [Header 3],1)

[jagan]

Hi,

Try like this

For Positive Count : Sum(If([Header4] >= 0, 1))

For Negative Count : Sum(If([Header4] < 0, 1))

Hope thsi helps you.

Regards,

Jagan.