title: How can I have complex formula field in a saved search
body: <p>I am new to Netsuite. I would like to compute a complex grouped result field in a saved search, say, average(price) * max(amount).</p>
  
  <p>I known SQL, and something called formula in Netsuite. I have tried composing a formula to compute it, but failed.</p>
  
  <p>Is it possible to compute such a complex filed with formula? If not, how ? Javascript custom code? Please give me a little hint, thanks. </p>