Totaling/Subtotaling a Calculated Field

[jawilson]

Good Morning all.

I have a formula field that I would like to subtotal by group. The problem is that one element of the formula is a summarized field (IE. {@UOP FCTR} * Sum ({PORECLINE.ENT_REC_QTY}, {ITEMMAST.ITEM}).

I would like to then subtotal the output of this formula by group, but from what I understand you cannot subtotal a summarized/calculated field.

Any ideas?
Thanks in advance,
Jamie Wilson

CRV 7.0

 

[kenhamady]

Create the formula:

{@UOP FCTR} * {PORECLINE.ENT_REC_QTY}

put this on the detail band and create your subtotals and grand totals from this formula.

Insert-Subtotal (select a group)
Insert-Grand total


Ken Hamady

http://www.kenhamady.com/

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