Recent

Author Topic: Subtracting group footer sums  (Read 2702 times)

mirce.vladimirov

  • Full Member
  • ***
  • Posts: 220
Subtracting group footer sums
« on: June 23, 2012, 03:20:59 pm »
I use group header in my reports, so i also have group footer which presents the sums of items contained in the master detail of a single group.
In the bottom of the report, i have a band "Report Summary" whic should calculate and present the  total on the whole report. Calculating a sum of values goes very simple : in the given memo's editor i write some code like :
Code: [Select]
[SUM([myLazarusQuery.MyFloatfield],BandName)]
But there is a case when I should subtract some groups from the total of all sums.
There should be a way to subtract totals of a certain Group, since there is a Grouping criteria-field, how can I do that ?