Searching a value in a column- JSL

[#1]

Hi All,

Can anyone help me with the search for a particular value in a column and try to find the count of that value with the overall count? In the below example, I am trying to search for value "1" in B column. I found 3 occurences in 10 instances so C is marked with 30%. Similarly for A=2, I found 4 occurence of "1" in 12 instances, so C is marked with 33%.

A	B	C
1	1	30%
1	87
1	90
1	65
1	1
1	65
1	3
1	1
1	34
1	5
2	1	33%
2	5
2	2
2	47
2	1
2	54
2	1
2	85
2	1
2	1
2	22
2	21

Thank you 

[#2]

You can do virtually anything you want to do in JMP, so yes, there are ways to do what you want.  However, the structure you have is a data table, and it's defaults are based upon a column based analysis table structure, not a cell based structure like Excel.  

To do what you are asking, I would do the following.

Go to "Column Info" for the percentage column.

In the Column Info window, remove the formula property.  This will keep the values, but take away the formula.

Then change the "Data Type" from numeric to character

Close the "Column Info" window

Now go and delete the cell values you don't want.