topic Re: Calculation grouped by variable in Discussions https://community.jmp.com/t5/Discussions/Calculation-grouped-by-variable/m-p/909433#M106812 <P>Thank you so much! That's exactly what I was looking for!</P> Thu, 23 Oct 2025 12:53:03 GMT DiCosimoA 2025-10-23T12:53:03Z Calculation grouped by variable https://community.jmp.com/t5/Discussions/Calculation-grouped-by-variable/m-p/909397#M106807 <P>Hello,</P> <P>I would like to find the maximum value from a column, but I need to group the data based on other columns; is it possible using a formula or a script?</P> <P>As example, I would like to populate a new column with the maximum height, but divided by age, sex and nationality:</P> <P>&nbsp;</P> <TABLE style="border-collapse: collapse; width: 192pt;" border="0" width="256" cellspacing="0" cellpadding="0"><COLGROUP><COL style="width: 48pt;" span="4" width="64" /> </COLGROUP> <TBODY> <TR style="height: 15.0pt;"> <TD width="64" height="20" style="height: 15.0pt; width: 48pt;">Nationality</TD> <TD width="64" style="width: 48pt;">Sex</TD> <TD width="64" style="width: 48pt;">Age</TD> <TD width="64" style="width: 48pt;">Height</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">ITA</TD> <TD>M</TD> <TD align="right">25</TD> <TD align="right">180</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">USA</TD> <TD>F</TD> <TD align="right">23</TD> <TD align="right">180</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">FRE</TD> <TD>M</TD> <TD align="right">24</TD> <TD align="right">168</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">FRE</TD> <TD>M</TD> <TD align="right">25</TD> <TD align="right">201</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">GER</TD> <TD>F</TD> <TD align="right">23</TD> <TD align="right">160</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">ITA</TD> <TD>X</TD> <TD align="right">23</TD> <TD align="right">175</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">ITA</TD> <TD>X</TD> <TD align="right">24</TD> <TD align="right">158</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">CAN</TD> <TD>M</TD> <TD align="right">25</TD> <TD align="right">193</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">USA</TD> <TD>F</TD> <TD align="right">23</TD> <TD align="right">170</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">SPA</TD> <TD>F</TD> <TD align="right">24</TD> <TD align="right">179</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">SPA</TD> <TD>X</TD> <TD align="right">25</TD> <TD align="right">169</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">GER</TD> <TD>F</TD> <TD align="right">23</TD> <TD align="right">163</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">GER</TD> <TD>M</TD> <TD align="right">24</TD> <TD align="right">185</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">CAN</TD> <TD>X</TD> <TD align="right">25</TD> <TD align="right">201</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">CAN</TD> <TD>M</TD> <TD align="right">23</TD> <TD align="right">193</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">ITA</TD> <TD>F</TD> <TD align="right">24</TD> <TD align="right">170</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">USA</TD> <TD>F</TD> <TD align="right">25</TD> <TD align="right">180</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">FRE</TD> <TD>X</TD> <TD align="right">23</TD> <TD align="right">179</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">FRE</TD> <TD>F</TD> <TD align="right">23</TD> <TD align="right">169</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">GER</TD> <TD>M</TD> <TD align="right">24</TD> <TD align="right">163</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">USA</TD> <TD>M</TD> <TD align="right">25</TD> <TD align="right">185</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">SPA</TD> <TD>F</TD> <TD align="right">23</TD> <TD align="right">180</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">SPA</TD> <TD>M</TD> <TD align="right">24</TD> <TD align="right">179</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">GER</TD> <TD>M</TD> <TD align="right">25</TD> <TD align="right">185</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">GER</TD> <TD>F</TD> <TD align="right">23</TD> <TD align="right">201</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">ITA</TD> <TD>X</TD> <TD align="right">24</TD> <TD align="right">193</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thank you in advance.</P> Thu, 23 Oct 2025 10:10:02 GMT https://community.jmp.com/t5/Discussions/Calculation-grouped-by-variable/m-p/909397#M106807 DiCosimoA 2025-10-23T10:10:02Z Re: Calculation grouped by variable https://community.jmp.com/t5/Discussions/Calculation-grouped-by-variable/m-p/909409#M106809 <PRE><CODE class=" language-jsl">Col Max( :Height, :Age, :Sex, :Nationality )</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_0-1761214939894.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/85587i930DC4034565C602/image-size/medium?v=v2&amp;px=400" role="button" title="txnelson_0-1761214939894.png" alt="txnelson_0-1761214939894.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 23 Oct 2025 10:22:34 GMT https://community.jmp.com/t5/Discussions/Calculation-grouped-by-variable/m-p/909409#M106809 txnelson 2025-10-23T10:22:34Z Re: Calculation grouped by variable https://community.jmp.com/t5/Discussions/Calculation-grouped-by-variable/m-p/909433#M106812 <P>Thank you so much! That's exactly what I was looking for!</P> Thu, 23 Oct 2025 12:53:03 GMT https://community.jmp.com/t5/Discussions/Calculation-grouped-by-variable/m-p/909433#M106812 DiCosimoA 2025-10-23T12:53:03Z