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