formula's within a group

[jobillborf]

Greetings, I am doing a report that groups data by stock # I would like to prepare three formulas for the following.

For each stock number (group)

formula 1. Sum Field {trnquantity} for field {trntype} is equal to "ISS"

formula 2. Sum Field {trnquantity} for field {trntype} is equal to "ADJ"

formula 3. Sum Field (trnquantity) for field {trntype} is equal to "Rec"

I would like this to appear within the stock # group

thank you

 

[kenhamady]

You need 3 conditional formulas, and then a subtotal of each formula. The formulas would look like this:

if {trntype} = "ISS"
then {trnquantity}
else 0 Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[jobillborf]

Ken. When I create the formula it totals ISS for the whole report. How do I a total for one group. Thank you

 

[kenhamady]

Write the formula that i suggested and put it on the detail band. Now click on that formula and select "Insert - Subtotal ".

Select the group by Stock. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)