2 Replies Latest reply on Sep 28, 2015 10:26 PM by Swarup K

    CALCULATE % FOR 2 COLUMNS

    mehul parekh

      Hello ,

      I need help understanding how to write a formula that can calculate % can and % completed in Tableau like it below that I did in excel.

      % cancelled and % completed are derived using formula(b2/d2)

      Thank you in advance

      Meh

       

      Count Based on MonthsQTY RejectedQTY ACCEPTEDTOTAL QTY% REJECTED%accepted
      JAN-15852546139860.94%39.06%
      FEB-15722580130255.45%44.55%
      MARCH-15765650141554.06%45.94%
      APRIL-15714651136552.31%47.69%
      MAY-15681719140048.64%51.36%
      JUNE-15741860160146.28%53.72%
      JULY-15834920175447.55%52.45%
      TOTAL QTY530949261023551.87%