2 Replies Latest reply on Mar 28, 2013 9:20 AM by John Haldeman

    What to do with a cell containing #N/A under 'Current Balance' column? <Excel>

    John Haldeman

      Background.

      Under my Current Balance column there are 3 options of a value. 

      1. If the account is paid in full it shows 0
      2. It shows the balance amount (e.g. $215.81)
      3. If the account had no had no activity the past month (didn't purchase anything) the field shows #N/A and I intend on filtering out this group

       

      Problem

      Tableau isn't showing anything for current balance on any account.  I have attached a screen shot of my tableau screen and the base data.*

       

       

      Thanks,

      John

       

      *The attached image is large, may require you to zoom out.