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