Results 1 to 2 of 2

Thread: Grand total for formula fields?

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2002
    Location
    top of the mountain
    Posts
    234

    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

  2. #2
    Hyperactive Member shirishdawane's Avatar
    Join Date
    Dec 2004
    Location
    Mumbai,India
    Posts
    363

    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
  •  



Click Here to Expand Forum to Full Width