newbie help please - query to check and agregate mulitple rows

[Una_R]

I have the following returned from a query

test a : result 1
test a : result 2
test a: no result
test b: no result
test c: no result
test c: result 4

and I want to generate a table showing tests which have AT LEAST 1 result

so
test a: has result
test b: has no result
test c: has result

I am very confused by the summary and aggregation documentation - is there a way to do this?

Thanks very much

[HalfBloodPrince]

try this
create count _calculation as

if (UPPER([Tes_Result_Column])contains 'TEST RESULT') then
(1)
else
(0)

then create another calculation as

if (total (count _calculation  ) >=1) then

('Has result')
else
('Has No Result')

[Una_R]

Thanks very much for your help
This worked

[Una_R]

Hi again

One last piece in the puzzle

I want to present a simple summary of the query data

test case   test case status
test 1    single result
test 2    no result
test 3    no result
test 4    single result
test 5    more than one result


summary should be

no result  2
single result 2
more than one result 1

This is driving me crazy as I thought I could just use the count distinct on the test case name (as I have in other reports to produce pie charts), but this always returns just one test case status ("more than one result")

Is there a standard way to do this?

Thanks again