6 Replies Latest reply on Sep 19, 2018 11:52 AM by Carsten Ideke

    Average Line without Zeros

    Carsten Ideke

      Hello,

       

      i want to calculate an Avg Line  without Zero Values.

       

      2018-09-19 19_49_57-Tableau - Tableau_Termin_RWV2.png

       

      This are the Values not on every Date is a Value so the real avg is  : 12.998.890 /23 =  565.169 ... but tableau shows 419000

       

      How can i fix it like divide only if value is > 0?

       

      Thanks.