2 Replies Latest reply on Feb 18, 2015 5:19 AM by wimdecorte

    How to subtract summary value from related table in sub-summary report

    user23934

      I am creating a summary report on earnings and outgoings.

       

      My report is on the earnings table, summarised by year and month, with sub summary of month displaying total earnings for the month, and from a related 'expenses' table total expenses for the month. Relationship is based on year and month.

       

      I have no problems displaying the summary values of total earnings and total expenses, but I can't figure out how to subtract one from the other.

       

      I gather I should be using the get summary function, but I can't seem to get it working for my related table value.

       

      Month and Year are a calculated value in both tables. The summary field from the related table calculates fine, it's only when I try to do a calculation subtracting one from the other I run into issues.

       

      Hope someone can give me a pointer on this.

       

      Thanks, Caitlin