6 Replies Latest reply on Oct 11, 2017 8:45 AM by Mine Safety

    Google sheets with formulas

    Asier de la Fuente

      Hi!

       

      I´m trying to use Tableau Public 10 with it´s new Google sheets import features, but i can´t

       

      The trouble i´ve encountered is the following:

       

      I have a Google spreadsheet with sales information.

      Commissions, taxes, etc., are calculated with a formula inside Google Sheets cells.

       

      When i load the sheet inside Tableau, y get all the values ok...if there are marked as "string"

      If i configure a row as "number" (with or without decimals) the cells that contains formulas appears as "null", so i can´t get numeric content in those cells to use inside Tableau 10.

       

      Any ideas on how to solve it?

       

      Thx!