count conditional

[#1]

Hello,

i need count some rows

example

DATE	NAME	EQUIP NAME	KIND OF ACTIVITY	START ACTIVITY	STATUS
31-8-12	HELMAN1	BOGOTA 1	M.P	22:00	OK
31-8-12	HELMAN1	BOGOTA 1	M.P	23:00	OK
1-9-12	WILMAR	BOGOTA 2	EMERGENCY	08:00	PENDING
1-9-12	LEONARDO	BOGOTA 3	TEST	07:00	PENDING

I need count the rows  that have the same information as one row.

i have this  comand line

Count

(DISTINCT [Kind of Activity]&Date&[Equipment Name])

With this i count the number of activties, but i need to add other condition that if de STATUS column is OK, the activity must to be count.

thank you.

[#2]

Hai,

you can use set analysis like

=Count({$<STATUs={"OK"}>}Kind Of Activity)

are you looking for this or something else

Thanks,

Mukram.

[pgalvezt]

=Count({$<STATUS={"OK"}>}Distinct Kind Of Activity)

Hope Help you!

[whiteline · Accepted solution]

=Count({$<STATUS={"OK"}>} [Kind of Activity]&Date&[Equipment Name])

[#5]

thank you

Helman

[#6]

thank you