4 Replies Latest reply on May 27, 2016 7:45 AM by Sanjay Nimbark

    SUM IF Calculation

    Renato Lyke

      Hi,

       

      How do we replicate the SUMIF Calculation that is in excel in Tableau.

       

      I have two columns, One Mertic and the Other number.

       

      I wish to get a sum if the metric is Closed.

       

      I have tried this and it sums up the entire values in the column and shows it under closed it self.

       

      SUM(IF[Metric]="Closed" THEN [Number] END)

       

      Any suggestions how to improve this and get accurate values.

       

      Regards,

      Renato.