Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 4 of 4
  1. #1
    Forum Member
    Join Date
    Aug 2012
    Posts
    2
    Location
    Kingscote, SA Australia
    FileMaker Pro Software
    14
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    05-18-2017
    Local Date
    10-20-2017
    Local Time
    07:55 PM
    Last Active
    09-21-2017

    Summary field not working as it should

    Hi - please be gentle, I have never posted anything on a forum before and am a newbie! I am having problems with a report and think it is a simple solution.
    I have a report for a number of different tours and summarise the amount of people on each tour:
    CountILPax = If (TourNameRefined = "Island Life" ; PaxNumbers)

    I then have a summary field:
    SummaryILPax = Total of CountILPax

    I have a calculation to determine the number of Island Life tours on a particular day:
    CountILTours = Case ( GetSummary ( SummaryILPax ; TourNameRefined ) ≤ 6 ; 1 ; GetSummary ( SummaryILPax ; TourNameRefined ) ≥ 18 ; 2)

    The CountILTours calculation works in the Sub Summary Part which is sorted by TourNameRefined

    In the Grand Summary Part I have a summary field:
    SummaryILTours = Total of CountILTours

    This field does not calculate as I want it to - it should be the total number of Island Life tours over the report but it comes up with a random number.

    I also tried to put a calculation field in there to see if that would work:
    GetSummaryILTours = GetSummary ( SummaryILTours; TourNameRefined )
    But that only calculated the number of Island Life records in the report

    I have attached a copy of the layout.

    Thanks in advance for any help you can provide.
    Attached Files Attached Files

  2. #2
    Senior Moderator - FMT Preferred Trainer - Consultant: Australia, New Zealand, Japan & Pacific Rim David Head's Avatar
    Join Date
    Apr 2001
    Posts
    2,892
    Location
    Sydney, NSW Australia
    FileMaker Pro Software
    FileMaker Pro 15 Advanced
    OS
    Windows & Mac
    Skill Level
    Developer
    Last Post
    10-17-2017
    Local Date
    10-20-2017
    Local Time
    09:25 PM
    Last Active
    10-19-2017
    Hi Jamie
    It would be useful to know your data structure -- what tables and relationships you have.
    And also an example of what you actually want as the report.
    You may be drawing the report from the wrong table but I cannot tell/
    Regards,
    David Head
    FileMaker 15 Certified Developer
    FBA Trainer
    LinkedIn Profile

    There is always a well-known solution to every human problem - neat, plausible, and wrong.
    H. L. Mencken, Prejudices: Second Series, 1920

  3. #3
    Forum Member
    Join Date
    Aug 2012
    Posts
    2
    Location
    Kingscote, SA Australia
    FileMaker Pro Software
    14
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    05-18-2017
    Local Date
    10-20-2017
    Local Time
    07:55 PM
    Last Active
    09-21-2017
    Hi David,
    Thanks for your reply. All but one of the fields are in the same table, which is the field Booking Status (shown as travelled on the pdf). Booking Status is from the Bookings table which is related d to this current table (Tour Day), by booking number. Basically, what I want to be able to do is produce a report to look at forward tours so that we can manage our stock ordering more efficiently.
    I hope this is enough information.
    thank you

  4. #4
    Senior Moderator - FMT Preferred Trainer - Consultant: Australia, New Zealand, Japan & Pacific Rim David Head's Avatar
    Join Date
    Apr 2001
    Posts
    2,892
    Location
    Sydney, NSW Australia
    FileMaker Pro Software
    FileMaker Pro 15 Advanced
    OS
    Windows & Mac
    Skill Level
    Developer
    Last Post
    10-17-2017
    Local Date
    10-20-2017
    Local Time
    09:25 PM
    Last Active
    10-19-2017
    Hmmm, not really enough information there yet.

    So you want a report summarised by date?

    And you want to know how many pax for each date -- which you have working.

    For this field: CountILPax = If (TourNameRefined = "Island Life" ; PaxNumbers)
    If all records are for Island Life, then surely CountILPax = "Total pax of above tour type on date" ?

    For this field:
    SummaryILPax = Total of CountILPax
    This makes sense and seems to be working.

    For this field: CountILTours = Case ( GetSummary ( SummaryILPax ; TourNameRefined ) ≤ 6 ; 1 ; GetSummary ( SummaryILPax ; TourNameRefined ) ≥ 18 ; 2)
    This seems to work as written but does not account for numbers between 7 and 17?

    What happens if you put the
    CountILTours field into the Trailing Grand Summary?

    It would be helpful if you mocked up a report that you wanted. It seems there is a lot of redundant/repeated data in the report you have shown.

    Cheers, David
    Regards,
    David Head
    FileMaker 15 Certified Developer
    FBA Trainer
    LinkedIn Profile

    There is always a well-known solution to every human problem - neat, plausible, and wrong.
    H. L. Mencken, Prejudices: Second Series, 1920

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Repetition field summary not working for all records
    By alienandra in forum FileMaker 13 - All Versions
    Replies: 7
    Last Post: 07-09-2015, 02:07 AM
  2. Filtering a summary report based on a summary field
    By rigas in forum FileMaker Pro 11
    Replies: 1
    Last Post: 07-13-2012, 08:41 PM
  3. Help! Calculated field Total of summary field giving incorrect result. Help!!!
    By ecpmII in forum Calculations and Define Fields
    Replies: 2
    Last Post: 03-15-2002, 06:03 PM
  4. Help! Calculated field Total of summary field giving incorrect result.
    By ecpmII in forum FileMaker Pro Versions 5 & 6
    Replies: 2
    Last Post: 03-08-2002, 02:47 AM
  5. Summary field giving incorrect result in trailing grand summary
    By ecpmII in forum Calculations and Define Fields
    Replies: 0
    Last Post: 03-04-2002, 02:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 42,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.