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!