Skip to Content
0
Former Member
Mar 27, 2009 at 03:19 PM

Crystal 2008 - How to use the total revenue in a formula

37 Views

Hi, Experts,

With Crystal report 2008, I created Income Statement in the following steps:

1. select the Journal Entries within a date range

2. group accounts by their father accounts

3. summarize father accounts under Revenue and Expense ( then I got Total Revenue and Total expense in my groupfoot)

Now, I'd like to calculate the percentage of

(Revenue or Expense under each father account) / (total revenue)

When I directly set the formula as: Sum ({@MonthBalance}, {OACT.FatherNum})/Sum ({@MonthBalance}, {@Seg0FirstLetter})

It gives the percentage of (Revenue or Expense under each father account) over (the summary of their group - Revenue or Expense)

Please help how could I use only the total revenue amount in my formula?

Thanks!

Lorrie

Edited by: Lorrie Liu on Mar 27, 2009 4:59 PM