Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% ?
Fixed this as well, no idea what the problem was but I just added a new measure with the same expression and it shows the correct percentage in the total column.