Forum Stats

  • 3,838,629 Users
  • 2,262,385 Discussions


Can we do subtraction for Grand Total in an anlysis


My requirement is to subtract two sub totals and show it in the analysis.

I have 2 account types like Expense,Revenue The grand total should be Total Revenue less expense.. Please let me know if it is possible & how can i achieve it ?

Thanks in advance



  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,640 Blue Diamond

    If "grant total" is the automated totals you enable at the view level, the aggregation works in a single way for all the rows.

    If you use something like Essbase where you defined your accounts dimension, you can set aggregation rules for every account at any level of the hierarchy.

    If you don't have that kind of source, you could replace the automated grant totals with calculated items where you set yourself the rules.