## suppressing the second record that matches the formula criteria

## suppressing the second record that matches the formula criteria

(OP)

I have been struggling with this report for days and found this site, useful for most of my problems with it but I can't seem to find the right solution to fix the final piece of it.

I have 4 groups

experiment

experiment group name

experiment subject ID

Day

I have the following in the footer of my Day and these work great: Day, result of the test for that day

Day 1 = 0

Day 2 = 0.5

Day 3 = 0.5

Day 4 = 2

I have used a running total to get the minimum value and created a formula

If ({table.results} = {#min})

then

{day}

else

0

and placed a suppress on if {@day} = 0

this works great but in the instance where I have 2 values that are the minimum the report is now giving me both days 2 and 3 when I only want to see day 2.

Any suggestions are greatly appreciated.

thanks

J

I have 4 groups

experiment

experiment group name

experiment subject ID

Day

I have the following in the footer of my Day and these work great: Day, result of the test for that day

Day 1 = 0

Day 2 = 0.5

Day 3 = 0.5

Day 4 = 2

I have used a running total to get the minimum value and created a formula

If ({table.results} = {#min})

then

{day}

else

0

and placed a suppress on if {@day} = 0

this works great but in the instance where I have 2 values that are the minimum the report is now giving me both days 2 and 3 when I only want to see day 2.

Any suggestions are greatly appreciated.

thanks

J

## RE: suppressing the second record that matches the formula criteria

And the I don't want to see 0 as the minimum value, thus I would like to have a field return day 2 only the the other fields suppressed(including day 3 where the values are the same) and this value will be placed either in the footer of either the experiment subject ID or Day

I have tried using the {table.results} = previous({table.results} ) and this, nor the Next function do not work

## RE: suppressing the second record that matches the formula criteria

Have you tried creating a separate formula to mark the records that you don't want to keep.

## CODE -->

{@day} = 0 or {@newformula)= 'Suppress'

Gordon

Crystalize

## RE: suppressing the second record that matches the formula criteria

I have attached a couple of screenshots to help clarify what is going on.

Thanks for the assistence

J

## RE: suppressing the second record that matches the formula criteria

So we can use a variable instead.

Create a formula placed in the SubjectId Group Header.

## CODE -->

## CODE -->

I haven't tested but something along these lines may work

Gordon

Crystalize

## RE: suppressing the second record that matches the formula criteria