I have a report that displays records by group and has a SUM expression in the Group Footer.
That worked perfectly.
However I need to show an Opening Balance above the records and then
include that Opening Balance in the SUM.
So, Instead of having this...
SUM Employee.AccruedDays
I need something like this...
Employee.OpeningBalance + SUM Employee.AccruedDays
Cannot get this to work so can someone please advise if it is doable and if so, what the correct method might be?
Variation to Group SubTotal in Report
-
- Posts: 2403
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Variation to Group SubTotal in Report
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....