4 Replies Latest reply on May 22, 2019 9:34 AM by Ken Flerlage

    How to Divide 2 calculated fields in Tableau

    Pavan Kumar poola

      Hi,

      There are 2 calculated fields and I need to do division on them...….Calc1 / Calc2 and this is giving me nulls. Unable to attach the workbook.

       

      I am just replicating the same example in Super store.

       

       

      1. Sub_cat_Chairs

      If [Sub-Category] = 'chairs' THEN [Sales]

      END

       

      1. Sub_cat_Tables

       

      If [Sub-Category] = 'Tables' THEN [Sales]

      END

       

      I need to do “Chairs by Tables” with below formula.

       

      [Sub_cat_Chairs]/[Sub_cat_Tables]

       

       

      When I pull this into rows I am getting null values,
      although we have values for the corresponding calculated fields. Please check attached SS.

      Can some one help me solve this issue so that I can apply
      the same in my Project.