division

[kfr104]

I am using the define function and when I am doing the division function I am getting number that are not correct...

I am dividing two P12 formats and trying to get a percentage...and it is not working out.

What am I doing wrong?

Thanks,
Kerry

 

[focwizard]

What numbers are you dividing, and HOW is the result incorrect?

 

[kfr104]

I used compute instead of Define and it worked. However, I have a column that I am doing CNT.DST and I want to use that number and divide it into sales but it does not work. What do I have to do to the formula to make it work?

Thanks,

 

[focwizard]

If it works with COMPUTE, and not DEFINE, that means you want the division to be done on the AGGREGATED values, not on the details. You can use PCT.CNT.field in a calculation, exactly as you used the verb objects. Here's an example:

TABLE FILE CAR
WRITE RCOST DCOST CNT.DST.BODYTYPE
COMPUTE RATIO=100*RCOST/DCOST * CNT.DST.BODYTYPE;
BY COUNTRY
END