Bennie47250
Programmer
Using Crystal Version 7.0 against an Access database
I have a report with 5 Different Groups.
Sales Region
Department
GL Account Number
Arm Type
Part Number
In the Arm Type group, there is a Formula named Avg Cost and it dividing a running total of the Qty Sold into the Running Total of the Total Material Cost. This formula is {#GF3TotalCost} / {#GF3Qty}
We have two different types of Arms, Blue and Red
On the report, we have one line that shows on the Blue arms the Avg Cost is $225.63.
Go a few lines down and there is a line that shows on the Red arms, the Avg Cost is 256.36.
I want to be able to subtract the Red Avg Cost from the Blue Avg Cost.
How can this be accomplished?
I have a report with 5 Different Groups.
Sales Region
Department
GL Account Number
Arm Type
Part Number
In the Arm Type group, there is a Formula named Avg Cost and it dividing a running total of the Qty Sold into the Running Total of the Total Material Cost. This formula is {#GF3TotalCost} / {#GF3Qty}
We have two different types of Arms, Blue and Red
On the report, we have one line that shows on the Blue arms the Avg Cost is $225.63.
Go a few lines down and there is a line that shows on the Red arms, the Avg Cost is 256.36.
I want to be able to subtract the Red Avg Cost from the Blue Avg Cost.
How can this be accomplished?