Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ???
Positive count expr: Count(If([Header 2] > [Header 3],1)
Negative count expr: Count(If([Header 2] < [Header 3],1)
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.