Count if null

[DavidMetodoyEmocion]

Hi

I would like count variable3 if:

• Variable1 is NULL
• Variable2 is NOT null
• Variable3 is NOT null

I write this formula, but it does not work:

• Count({<variable3-={0}, varaible2-={0}, variable1=0>} variable3)

Could you please help me?

Thanks a lot!

D

[Taoufiq_Zarra]

can you develop your post or share a sample data ?

[DavidMetodoyEmocion]

Thanks

I want to count "Etapa3" if

1. "Etapa3" is not null.
2. "Etapa2" is null.
3. "Etapa1" is not null

If we take a look over my example (bellow), the result is 3.

Thans a lot!

D

etapa 1	etapa2	etapa3
2/1/19 7:32		9/4/19 8:33
	9/1/19 6:18
	10/1/19 6:18
	11/1/19 6:18
	8/1/19 6:19
	8/1/19 6:19
	8/1/19 6:18
2/1/19 14:32	10/1/19 7:07
	8/1/19 6:21
	8/1/19 6:20
	8/1/19 6:20
	8/1/19 6:20
	8/1/19 6:19
	8/1/19 6:19	11/1/19 8:50
	8/1/19 6:20
14/1/19 8:58	4/3/19 10:31
8/1/19 12:17		27/1/19 12:13
15/1/19 11:58	13/2/19 17:23
14/1/19 9:43
30/1/19 8:47	5/3/19 20:08
11/1/19 8:55		31/3/19 11:44

[asinha1991 · Accepted solution]

probably this

count (if(not isnull(variable3) and not isnull(Variable2) and isnull(variable1),variable3))