Case Calculations
I want to give text definitions to three criterea and used the following formula;
Case ( sum 8 9 > sum 10 proj ; "Decline" ;
sum 10 proj > sum 8 9 ; "Ascent" ;
sum 10 proj = 0 ; "Closed" )
There are two calculation fields at work here, the sum of sales for 08 and 09 and the sum of 10 and projected 11. The first two parts of the case calc work fine however I wanted any companies with 0 sales for 10 & 11 to be defined as closed. What I get is only companies that had sales prior to 2008 or only sales in 2011. Where did I go wrong?
Case ( sum 10 proj = 0 ; "Closed" ;
sum 8 9 > sum 10 proj ; "Decline" ;
sum 10 proj > sum 8 9 ; "Ascent"
)