Conditional Coount

Hi,
how do I condittionally count the result of a field. Like count if of
something like that...
thanks...Try this:
=Sum(iif(Fields!X.Value = "SpecialValue", 1, 0))
or this:
=Count(iif(Fields!X.Value = "SpecialValue", Fields!X.Value, Nothing))
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"C a r l o s - A n t o n i o" <carlvazpr?arroba¿yahoo.com> wrote in message
news:uBZccw2oFHA.572@.TK2MSFTNGP15.phx.gbl...
> Hi,
> how do I condittionally count the result of a field. Like count if of
> something like that...
>
> thanks...
>
>|||with little changes it worked pretty well. Thanks for your help...
:)
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:O%2395rZ5oFHA.2156@.TK2MSFTNGP09.phx.gbl...
> Try this:
> =Sum(iif(Fields!X.Value = "SpecialValue", 1, 0))
> or this:
> =Count(iif(Fields!X.Value = "SpecialValue", Fields!X.Value, Nothing))
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "C a r l o s - A n t o n i o" <carlvazpr?arroba¿yahoo.com> wrote in
> message news:uBZccw2oFHA.572@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> how do I condittionally count the result of a field. Like count if of
>> something like that...
>>
>> thanks...
>>
>