I currently have this compute which compares a headcount from the previous year to the current year.

 COMPUTE inc_dec_oct/I3 = HEAD_COUNT.OCT_13 - HEAD_COUNT.OCT_12; AS Inc/Dec  

Displays this:

Job Title Oct 12 Oct 13 Inc/Dec

Cook 5 3 -2

I would like to add a percent column to get this:

Job Title Oct 12 Oct 13 Inc/Dec Percent

Cook 5 3 -2 (40%)

Adding this gives me a percent but its backwards. I am getting 60% not (40%)

 COMPUTE oct_perct/I3% = (HEAD_COUNT.OCT_12/HEAD_COUNT.OCT_13) * 100; AS Percent  

Also the headcount can go up so maybe I need a DEFINE with some IF GT or IF LT to get the proper percentage?

This message has been edited. Last edited by: Greg,

quote:

COMPUTE oct_perct/I3% = (HEAD_COUNT.OCT_12/HEAD_COUNT.OCT_13) * 100; AS Percent

This shows the percentage of oct_12 in oct_13. What you say you say you want is the decrease.
So use:

  
COMPUTE oct_perct/I3% = ((HEAD_COUNT.OCT_13 -HEAD_COUNT.OCT_12)/HEAD_COUNT.OCT_13) * 100; AS Percent

However you will have to take into account the difference between decrease and increase.

quote:

However you will have to take into account the difference between decrease and increase.

I think I will a DEFINE to determine GT and LT.