2 Replies Latest reply on Sep 9, 2016 7:36 AM by David Li

    WINDOWS_SUM ZERO

    Mauricio Gomez Celis

      I have a problem with Calculated Fields in Tableau Desktop, When i use Windows_SUM and the row is empty the result is 0 When i need to see the total sum.

       

      My formula is like this: WINDOW_SUM(ZN(Sum(ZN([cfVentas]))), -6, 0), The Problem is that my info dont include the 0 rows and WINDOW_SUM ignore the fields.

       

       

      Any help?