|
-
Apr 12th, 2005, 02:02 PM
#1
Thread Starter
Addicted Member
Grand total for formula fields?
Hi,
in report I have group and in group footer formula field (@f1):
Code:
if sum(detail.field)>0 then
sum(detail.field)
else
0
Now I can't get grand total of @f1, I get error 'This filed cannot be summarized.'.
In this report I need to get grand total, but if sum(detail.field) in group is less then zero in grand total I need to add zero not to add negative value.
Did anybody know how to do this?
regard j
-
Apr 13th, 2005, 06:47 AM
#2
Hyperactive Member
Re: Grand total for formula fields?
if that field is existed in your data base then make your calcualtion or write your condition n running total field. you will get its grand total. but your filed should not be any formula field or running toTAL FILED.
On Error GoTo http://www.vbforums.com
Note :
1) Please use [vbcode]your code goes in here [/vbcode] tags when posting VB code.
2) Please mark thread as Resolved using the Thread Tools menu, if you got solution.
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
|