1 Reply Latest reply: Oct 28, 2016 3:33 PM by Shaun Fleishman RSS

    Null in totals row?

    Shaun Fleishman

      Can anyone tell me why a null would be displaying in the totals row when all the fields have data that the column is referencing?

       

      The work order closure rate expression is set as "([Total Closed Work Requests]/[Total Opened Work Requests])" in my table.

       

      Total opened and total closed columns all have a values and each of the closure rates for the individual have a closure rate as well, why would the totals be null when it should be 69/58 = 119% ?

       

      null_field.png