title: How to use bigquery round up results to 4 digits after decimal point?
body: <p>We don't have decimal data type in BigQuery now. So I have to use float</p>
  
  <p>But</p>
  
  <p>In Bigquery float division</p>
  
  <p>0.029*50/100=0.014500000000000002</p>
  
  <p>Although</p>
  
  <p>0.021*50/100=0.0105</p>
  
  <p>To round the value up</p>
  
  <p>I have to use round(floatvalue*10000)/10000.</p>
  
  <p>Is this the right way to deal with decimal data type now in BigQuery?</p>