title: How to make Google Studio Handle Blank values in my source (google sheet) when creating calculated fields
body: <p>I'm trying to create a field in Google Data Studio that would sum 5 different fields (my source), the problem is those values are currently blank (the sheet is reading from another system), but i want to create the field anyway for when the values are feeded in. Google Data Studio is telling me the field cannot be deleted</p>
  
  <p>I've tried to handle with <code>CASE if X is null then 0...</code> but this isnt working, when i try to manualy add data into the sheet (the source) it works, but then when i delete it the scorecard i'm using is returning error</p>
  
  <p>This is the code for one of the 5 fields i'm trying create.</p>
  
  <p>The 1 to 5 range is the range of all possible values in the spreadsheet.</p>
  
  <p>Field A:</p>
  
  <pre><code>case
      when X IS NULL then 0
      when X = 1 then 1
      when X = 2 then 2
      when X = 3 then 3
      when X = 4 then 4
      when X = 5 then 5
  else 0
  end
  </code></pre>
  
  <p>Failed to create field. Please try again later... this is when i try to create the field when the values of the fields in the spreadsheet are blanks.</p>