Our Preferred 5 Star Hosting Provider - Award Wining FileMaker Pro Hosting
Results 1 to 4 of 4
  1. #1
    FREE Member
    Join Date
    Sep 2012
    Posts
    43
    Location
    Phoenix, AZ USA
    FileMaker Version
    FM 11 Developer
    OS
    Windows
    Skill Level
    Novice
    Downloads
    0
    Uploads
    0

    Creating a Report with Calculations

    I will try and explain this the best I can as I am newer to FileMaker Pro 11.

    I have a report created that shows the results of pregnancy test (radio button) and a retest (also a radio button). What I would like to do is create one field that pulls the results of the first pregnancy test unless there is a restest, then it would pull from that.

    Does anyone know how I would do that?

    Thanks!
    Warning: This is an Old Thread
    This discussion is older than 420 days. information contained in it may no longer be current

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - New York - Worldwide AHunter3's Avatar
    Join Date
    Aug 2006
    Posts
    11,490
    Location
    New York and Nassau County, NY, USA
    FileMaker Version
    FM 9, FM 9 Server, FM 10, FM 11, FM 11 Server, FM 12, FM 12 Developer
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: Creating a Report with Calculations

    Define a calculation field, result type either "text" or "date" or "number" depending on what the "results of pregnancy test" and "retest" actually are —— whether THEY are dates, text strings, or numbers.

    The formula for that calculation field should be:


    Case (IsEmpty (RetestField); PregnancyTestField; RetestField)




    Put that new calcfield on your report.

  3. #3
    FREE Member
    Join Date
    Sep 2012
    Posts
    43
    Location
    Phoenix, AZ USA
    FileMaker Version
    FM 11 Developer
    OS
    Windows
    Skill Level
    Novice
    Downloads
    0
    Uploads
    0

    Re: Creating a Report with Calculations

    It's a text field. Right now this is the calculation that I have.

    If ( PT Result = "Positive" ; "Positive") & If ( PT Result = "Negative" ; "Negative") & If (PT Result = "Negative" and RT Results = "Positive" ; "Positive") & If (PT Result = "Negative" and RT Results = "Negative" ; "Negative")

    It's working for the PT Result but it's not working for the RT Results. Do you have any idea why or how I could fix it?

  4. #4
    FREE Member
    Join Date
    Sep 2012
    Posts
    43
    Location
    Phoenix, AZ USA
    FileMaker Version
    FM 11 Developer
    OS
    Windows
    Skill Level
    Novice
    Downloads
    0
    Uploads
    0

    Re: Creating a Report with Calculations

    I've actually gotten it to work by using this calculation - If ( PT Result = "Positive" ; "Positive" ) & If ( PT Result = "Negative" ; "Negative") & If (PT Result = "Positive" or RT Results = "Positive" ; "Positive") & If (PT Result = "Negative" or RT Results = "Negative" ; "Negative")

    However, it's showing PositivePositive or NegativeNegative for clients who have only been in for a PT Result. Any ideas on how to fix it?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 09-21-2010, 03:55 PM
  2. Report calculations in SubTotals
    By saubolle in forum FileMaker Pro 10
    Replies: 3
    Last Post: 08-13-2009, 01:19 PM
  3. exporting summary report and calculations
    By DBMan in forum Exporting and Importing
    Replies: 1
    Last Post: 09-15-2008, 02:47 PM
  4. Creating a Report With Calculations
    By scarysnow in forum FileMaker Pro 9
    Replies: 0
    Last Post: 04-02-2008, 08:21 AM
  5. Calculations for report
    By dbdesign in forum Calculations and Define Fields
    Replies: 0
    Last Post: 03-24-2006, 11:30 AM

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 solutions and solve your technical challenges. 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.