Pete Marler

Pete Marler

  • NA
  • 8
  • 1.3k

Two Activity Flags on page, cannot show both at same time.

Aug 5 2015 7:49 AM
Good afternoon
 
I have to two activity flag fields on one page, which are tick boxes.
 
I have written a formula for a report to show when the boxes are ticked.  
If {TBLITEM.ACTIVITYFLAG} = 1152 Then
"Positive Test"
else
If {TBLITEM.ACTIVITYFLAG} = 2176 Then
"Positive Result"
 
This works fine if one or the other box is ticked, but will not work when both boxes are ticked (as they will sometimes need to be). 
 
Can anyone help solve this so that I can tick both boxes and they will show up on the report?  
 

Answers (5)