Max of the column in SharePoint (formula)
<p>have a simple list with column Name and Price.
I've inserted values:</p>

<pre><code>Name | Price
-------------
A    |   3
-------------
B    |   30
</code></pre>

<p>I need to get the maximum of all Price values inserted before to make a check if price in inserted record is bigger than existing maximum (something like auction). </p>

<p>But =Price>MAX(Price) isn't working, cause it is checking only existing record. Is there ane agregation functions for my task? </p>