-
March 15th, 2013, 04:05 AM
#1
Group By,sum
Goodmorning
I want little help again.
I have a field (1,2,3 values) that i have done it group by so i take something like that
1.Income
1 Thomas test 40
2 thomas test2 30
sum:70
2.Spends
1.thomas test 23
2.thomas test 35
sum:58
Total sum: income:70- spend:58
*Now i have done all the above but i cant do the last row. I dont know what field to put and how i can sum my groups above
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)
Storesum 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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|