0 Replies Latest reply on Aug 3, 2015 12:06 PM by choracy69

# The occurrence of analysis

Hi,

I have a question about building analysis and built-in functions. I have a column with seven records with the values of: 0,0,0,0,2,2,2 (in any order). How do I make my next column verify at that, if the whole column, even though there is only one value of 0, the entire column assumes 0, and if they are all different from 0 to some other value?

Like this:

Column 1  ||  Column 2

0     ||     0

0    ||     0

0    ||     0

2    ||     0

2    ||     0

0    ||     0

2    ||     0

or if i have only number diffrent from 0:

Column 1  ||  Column 2

2     ||     2

2    ||     2

6    ||     2

2    ||     2

4    ||     2

2    ||     2

1    ||     2

I have one more question, if column A is in a single analysis (detailed) can I described the operation to add a second analysis, that is to say that they were all 0 or 2 in a column in the second analysis (overall) I'll have one record and to make it 0 or 2?