count function Reportnet

[nnaife]

Hi Folks

I'm having a little problem with the Reportnet/Report Studio count aggregation function.

I've basically got a column called Paxtype datatype/length varchar(1)

This column has values of 'A' or 'C' or 'I'

I'm trying to create a calculation that counts the number of instances of the value 'A'
so the current calc i've created to perform this, looks like count([PAXTYPE] for [PAXTYPE],'A')

But this calc just ends up giving me a count of all values rather just a count of 'A' values.

Any pointers on how i can rewrite this expression to return a count of 'A' values only would be gratefully appreciated.

Thanks in advance.

Cheers
Nnaife