2 Replies Latest reply on Mar 2, 2016 12:04 PM by Nirupam Haas Tirukkovalluri

    Exclude zero if entire row is zero

    raghu.l

      hi,

       

      how to exclude zero, if entire row is zero.In the attached workbook you can see 4 measures are used. If i unchecked , "unexcused absence" measure then some rows will become zero.if i add again it should show the same data.

      But don't write calculated by adding all measures in calculated field using or / and logic, because if you have n-number of measure u need to add all to calculated field.