2 Replies Latest reply on Nov 27, 2018 3:55 PM by Mikey Michaels

    Transferring SUMPRODUCT function from Excel to Tableau

    Mikey Michaels

      Hi All,

      I need help creating a calculated field to mirror what I have wrote in Excel.

      If you look at row 1133, you will see that I have a SUMProduct calculation (e.g. =SUMPRODUCT(--($B$2:$B$1131>=EOMONTH(M$1,-1)+1)*--($B$2:$B$1131<=M$1)*--($A$2:$A$1131<>"Nullify"),($G$2:$G$1131))

       

      Any and all help is much appreciated!

       

      Cheers,

      Mikey