Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I would like count variable3 if:
I write this formula, but it does not work:
Could you please help me?
Thanks a lot!
D
probably this
count (if(not isnull(variable3) and not isnull(Variable2) and isnull(variable1),variable3))
can you develop your post or share a sample data ?
Thanks
I want to count "Etapa3" if
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 |
probably this
count (if(not isnull(variable3) and not isnull(Variable2) and isnull(variable1),variable3))