cancel
Showing results for 
Search instead for 
Did you mean: 

Hide table in a break

0 Kudos

Hello... Looking for a way to hide parts of a table. The table has a break by ID. Within the table of each ID are rows that include certain tests. Some of the ID's include multiple tests while others include only 1 type of test. I want to hide the tables where only one of the tests are listed. Tried adding a count by test type but this only returned a value for the individual rows (0 or 1). I want to hide the table if each row is equal 1. Where the table has both a 0 and 1, that means both tests are included and should not be hidden. Thoughts?

Thanks

Example:

ID Person Test

123 Name

test1 (1)

testa (0)

test1 (1)

test1 (1)

testb (0)

1234 Name

test1 (1)

test1 (1)

test1 (1)

test1 (1)

ID 1234 would need to be hidden since there is only one of the tests in the rows. There can be many rows of tests. Added the (0) or (1) next to each which is a variable I tried to use as a filter but this logic does not work. Only want to filter when ALL are (1).

Accepted Solutions (1)

Accepted Solutions (1)

kohesco
Active Contributor
0 Kudos

variable max0 =Count ([Test]) Where ([Test] = "0") In ([ID])

variable max1 = Count ([Test]) Where ([Test] = "1") In ([ID])

variable check =If [max0] + [max1] = 2 Then "SHOW" ELSE "HIDE"

filter check = HIDE

Answers (1)

Answers (1)

0 Kudos

Koen,

Nice! That worked great. Thank You for your help.