Re: Percentage at group level of Crystal Report.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

  • 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)
  • Re: Conditional create table
    ... If fielda is non-blank, ... if fieldb is non-blank, ... if fieldc is non-blank, ... You can put text, complete tables, and field codes inside the IF "results" as I have indicated. ...
    (microsoft.public.word.mailmerge.fields)
  • 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)