How do I compute a percentage subtotal in IQ?
The IQ User's Guide states "to create a subtotal that is a percentage in IQ for UNIX or Windows, you must multiply by 100 before dividing. For instance, to create a tuition percentage column rather than a tuition ratio column, perform the calculations in this order:
1. Multiply TUITION by 100 to get TEMP.
2. Divide TEMP by ORIG-TOTAL-DUE to get TUITION-PCT.
The proper order of the commands within your procedure would be:
MULTIPLY TUITION TIMES 100 GIVING TEMP.
DIVIDE TEMP BY ORIG-TOTAL-DUE GIVING TUITION-PCT."
- FAQ:
