Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Alaska
    Posts
    19

    Angry Unanswered: Stumped on a Calculation for a Report

    Can you please give me a hand on this. The answer is probably in front of my nose, but I haven't found it yet and I've been struggling with this all day. I'm still fairly new to this....

    On my report I have two fields that I'm trying to grab a total from.

    The two fields I have are as follows:

    OfflineReasonID
    TotalHoursOffline

    The current report I have lists the OfflineReasonID and TotalHoursOffline by date for any user defined period. It also has a Sum field totaling the entire TotalHoursOffline.

    In addition to the above, I would like to create another field on this report that would give me a total of TotalHoursOffline based on a specific value in the OfflineReason field for the user defined period?

    I need the Sum of TotalHoursOffline where OfflineReasonID = 1000
    and just for the time frame that the user entered for this report.

    Any ideas how this might be accomplished? Thanks for any help.

  2. #2
    Join Date
    Oct 2002
    Location
    NSW Australia
    Posts
    61
    In your source query for the report you need to add another column.
    eg.
    where you would normally drag a field down to, instead just type:

    MySpecificTotal: sum(iif([OfflineReasonId] = 1000,[TotalhoursOffline],0))

    Your query must be a GroupBy query for this to work.

    HTH

    :0)

  3. #3
    Join Date
    Dec 2002
    Location
    Alaska
    Posts
    19

    Thank You denofdeath!

    denofdeath

    Thanks for the help. Your answer worked really well.

    Cheers!



    Originally posted by denofdeath
    In your source query for the report you need to add another column.
    eg.
    where you would normally drag a field down to, instead just type:

    MySpecificTotal: sum(iif([OfflineReasonId] = 1000,[TotalhoursOffline],0))

    Your query must be a GroupBy query for this to work.

    HTH

    :0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •