title: BigQuery - convert scientific notation to decimal format
body: <pre><code>SELECT 
      SUM(totals.totalTransactionRevenue) *0.20 AS COGS
  FROM `bigquery-public-data.google_analytics_sample.ga_sessions_*` 
  WHERE _TABLE_SUFFIX BETWEEN '20170701' AND '20170701';
  </code></pre>
  
  <p>Why does BigQuery automatically convert the created field 'Cost Of Goods Sold - COGS' to scientific notation?
  and how can i amend this query to pull the COGS as a decimal format value?</p>
  
  <p><img src="https://i.stack.imgur.com/btUgr.jpg" alt="enter image description here"></p>
  
  <p>Thanks.</p>