Re: Percentage at group level of Crystal Report.

In news:GESge.1836$3%4.1598@xxxxxxxxxxxxxxxxxxxxxxxxxx,
Phil Hellmuth <billort@xxxxxxxxxxx> rambled:
> I have three fields on a Crystal report (v9.0), FieldA, FieldB and
> FieldC. FieldC is a formula field, dividing FieldA by FieldB. At a
> group level, I sum the values of FieldA and FieldB, but am at a loss
> as to how to create a group level value for FieldC, where I'd like to
> perform the same calculation on the group level sums for FieldA and
> FieldB.
>
> Any help would be greatly appreciated.

To elaborate on Iain's reply, you'll want to use an aggregate function
(probably SUM, but I guess it all depends on what you're actually trying to
do). Create a summary field (right click the field, choose subtotal) in the
group footer for FieldA. Do the same for FieldB. Then, create a new formula
that does the same calculation as FieldC, but use the aggregate fields. So
your new "percentage formula" will look like this:

//PercentageFormula
SUM(FieldA, GroupField) / SUM(FieldB, GroupField)


HTH.

--

KB - MCNGP "silent thug" #26

Briscobar AT gmail DOT com

You can check out Kat's hawt pics...er, pic...at www.mcngp.com.


.

Relevant Pages

  • Percentage at group level of Crystal Report.
    ... I have three fields on a Crystal report, FieldA, FieldB and FieldC. ... At a group level, I sum the values of FieldA and FieldB, but am at a loss as to how to create a group level value for FieldC, where I'd like to perform the same calculation on the group level sums for FieldA and FieldB. ...
    (microsoft.public.vb.crystal)
  • Re: Query:When 1 field in a table is not = to another field (same tab
    ... WHERE NOT(fieldA IN(fieldB, fieldC) OR fieldB IN) ... saved as, say, qu1, then ...
    (microsoft.public.access.queries)
  • Pivot Grand total on Selected columns only
    ... each day has 4 data fileds (fieldA, FieldB, fieldC, FieldD)+ extra ... i need to find a way of showing Grand total which sum up ONLY ...
    (microsoft.public.excel.programming)
  • Forms & Calcs & Populating a table
    ... Does anyone know whether or not this is possible without writing code for it. ... Now back on the form, FieldC is set up, for the moment, to visually display the product of FieldA and FieldB through the Control Source in Properties being set to do a calculation. ...
    (microsoft.public.access.forms)
  • Re: Percentage at group level of Crystal Report.
    ... >I have three fields on a Crystal report, FieldA, FieldB and FieldC. ... At a group level, I ...
    (microsoft.public.vb.crystal)