AnsweredAssumed Answered

Using sub summary totals in calculations

Question asked by NathanVeitch on Jun 11, 2014
Latest reply on Jun 12, 2014 by NathanVeitch

Title

Using sub summary totals in calculations

Post

Hi There,

I need a little advice on playing around with sub summary totals. I am trying to display an income statement. I have been able to get the sub summaries working where it shows me the totals for the different sections, eg Revenue, Expense, Interest, Tax and Dividends. Now I need to work the report so that the totals shown would be: 


    Total of Revenue - made up of all the revenue amounts
    Total of Expense - made up of all the expense amounts
Income before tax and interest (Total of Revenue - Total of Expense)
    Total of Interest - made up of all the interest amounts
Income before Tax ( Income before tax and interest + Total of interest)
    Total of Tax - made up of all the tax amounts
Income after Tax ( Income before tax - Total of Tax)
    Total of Dividends - made up of all the dividends amounts
Retained Income ( Income after Tax - Total of Dividends)

Im thinking of creating a new field to base the sub summary for the income before/after sections, but im stuck on how to work the calculation. The Total of sub summaries are working at the moment.

Outcomes