topic Re: byVar in Discussions

byVar

camlesse — Thu, 21 Jan 2016 01:42:47 GMT

Please excuse the simplicity of the request. I am trying to use a column formula to determine the quintile for a column of values that are divided into specific groups in another column. The data look something like this:

ClassYear	ClassRank	Quintile
2010	1
2010	2
2010	3
2010	4
2010	5
2011	1
2011	2
2011	3

I want the formula in the quintile column to determine in what quintile the class rank is depending on the year. I cannot get the correct syntax in the formula to make the calculation. All attempts to use Quantile [;ClassRank, :ClassYear] result in only Class Rank appearing in the column formula. Any suggestions?

Re: byVar

ron_horne — Fri, 28 Oct 2016 13:23:34 GMT

hi camlesse

follow this path:

Calculating Col Quantile by columns

Best,

ron

Re: byVar

camlesse — Fri, 22 Jan 2016 02:28:51 GMT

Thanks Ron. Very helpful!

Re: byVar

Mark_Bailey — Fri, 22 Jan 2016 15:25:41 GMT

The Summarize() function is also simple to use but quite powerful when you have a By variable to consider.