<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Formula does not apply to the column in Discussions</title>
    <link>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936352#M109177</link>
    <description>&lt;P&gt;It does not apply the formula&lt;/P&gt;</description>
    <pubDate>Fri, 20 Mar 2026 10:57:19 GMT</pubDate>
    <dc:creator>Lourdes</dc:creator>
    <dc:date>2026-03-20T10:57:19Z</dc:date>
    <item>
      <title>Formula does not apply to the column</title>
      <link>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936331#M109174</link>
      <description>&lt;P&gt;I have this table, and I want the average of the column EC(mS/cm) on the column next to it, group by name.&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2026-03-20 114153.png" style="width: 400px;"&gt;&lt;img src="https://community.jmp.com/t5/image/serverpage/image-id/96525i86356707F71FE4FD/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Screenshot 2026-03-20 114153.png" alt="Screenshot 2026-03-20 114153.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I used this formula yesterday but today it does not work when I apply it to the column.&lt;/P&gt;
&lt;DIV&gt;If( Row() == Col Min( As Column( "EC (mS/cm)" ) &amp;lt;&amp;lt; By( :Name ) ),&lt;/DIV&gt;
&lt;DIV&gt;&lt;SPAN&gt; Col Mean( As Column( "EC (mS/cm)" ) &amp;lt;&amp;lt; By( :Name ) ),&lt;/SPAN&gt;&lt;/DIV&gt;
&lt;DIV&gt;&lt;SPAN&gt; .&lt;/SPAN&gt;&lt;/DIV&gt;
&lt;DIV&gt;)&lt;/DIV&gt;
&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;
&lt;DIV&gt;Thank you in advance!&lt;/DIV&gt;</description>
      <pubDate>Fri, 20 Mar 2026 10:43:28 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936331#M109174</guid>
      <dc:creator>Lourdes</dc:creator>
      <dc:date>2026-03-20T10:43:28Z</dc:date>
    </item>
    <item>
      <title>Re: Formula does not apply to the column</title>
      <link>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936351#M109176</link>
      <description>&lt;PRE&gt;&lt;CODE class=" language-jsl"&gt;If(Row() == Col Min("EC (mS/cm)"n, :Name),
	Col Mean("EC (mS/cm)"n, :Name)
);
&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Fri, 20 Mar 2026 10:53:41 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936351#M109176</guid>
      <dc:creator>jthi</dc:creator>
      <dc:date>2026-03-20T10:53:41Z</dc:date>
    </item>
    <item>
      <title>Re: Formula does not apply to the column</title>
      <link>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936352#M109177</link>
      <description>&lt;P&gt;It does not apply the formula&lt;/P&gt;</description>
      <pubDate>Fri, 20 Mar 2026 10:57:19 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936352#M109177</guid>
      <dc:creator>Lourdes</dc:creator>
      <dc:date>2026-03-20T10:57:19Z</dc:date>
    </item>
    <item>
      <title>Re: Formula does not apply to the column</title>
      <link>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936355#M109178</link>
      <description>&lt;P&gt;Is your formula supressed?&lt;/P&gt;</description>
      <pubDate>Fri, 20 Mar 2026 11:14:01 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936355#M109178</guid>
      <dc:creator>jthi</dc:creator>
      <dc:date>2026-03-20T11:14:01Z</dc:date>
    </item>
    <item>
      <title>Re: Formula does not apply to the column</title>
      <link>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936365#M109179</link>
      <description>&lt;P&gt;I used this one and it worked:&amp;nbsp;&lt;/P&gt;
&lt;P&gt;If(&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp; Row() == Col Min( Row(), :Name ),&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Col Mean( :"EC (mS/cm)", :Name ),&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&amp;nbsp; .&lt;/P&gt;
&lt;P&gt;)&lt;/P&gt;</description>
      <pubDate>Fri, 20 Mar 2026 12:09:22 GMT</pubDate>
      <guid>https://community.jmp.com/t5/Discussions/Formula-does-not-apply-to-the-column/m-p/936365#M109179</guid>
      <dc:creator>Lourdes</dc:creator>
      <dc:date>2026-03-20T12:09:22Z</dc:date>
    </item>
  </channel>
</rss>

