3 Replies Latest reply on Aug 13, 2018 6:10 AM by Okechukwu Ossai

    Column Calculation from Excel to Tableau using calculated field

    Benedict Sebastian

      Hi,

       

      I am trying to achieve a simple excel calculation in tableau. However I am a bit stuck. The formula used for the new column  is in the attached spreadsheet.(I4 and I5)

      Attached packaged workbook ie work in progress . I am trying to replicate new column field in tableau using calculated field.

       

      Calculated fields step1 and Step2 and Step 3 are my attempt at achieving the goal

       

      Any help is appreciated.

       

      Simon Runc

      Zhouyi Zhang

      Mavis Liu