Creating a Report with Calculations

[tussing515]

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!

[AHunter3]

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.

[tussing515]

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?

[tussing515]

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?