2 Replies Latest reply on Apr 9, 2012 1:33 PM by muthumari.shanmugasundaram

    Need help with calculations

      I need to add a field (Y) based on 2 fields ( A,B ) which should be aggregated based on the selections the user chooses from the filter. I have the data updated day-wise.

       

      Right now, when I add calculated field and put
      Y: IF B = 0 THEN 0 ELSE A/B END
      Tableau is calculating A/B for every row and then summing up. But I want it to do SUM(A)/Sum( B ). How can I get this done?