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

    SUM IF Calculation

    Renato Lyke



      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.