I create a formula field and i have done something like that.

shared numbervar rtTotal;

if({Emp016.PelProm}="1") Then
rtTotal:=rtTotal+Sum ({Emp016.SynTeliko})

where the field pelprom is the field i group by and take values (1,2,3) and the field synteliko is the field with ammounds.

Now i want to get that at the end of report and not at the end of every group

GrandTotals
---------------------
Incomes: (sum of group with value 1)
Spends:  (Sum of group with value 2)
Store:(sum of group with value 3)
Total: Incomes-Spends-Store

So at the end i want 4  new fields but i dont know how to do it...Any help?


Edited by Melina291 - 14 Mar 2013 at 10:39pm