topic Re: Null in totals row? in App Development https://community.qlik.com/t5/App-Development/Null-in-totals-row/m-p/1200300#M22744 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Fri, 28 Oct 2016 19:33:59 GMT 2016-10-28T19:33:59Z Null in totals row? https://community.qlik.com/t5/App-Development/Null-in-totals-row/m-p/1200299#M22743 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>The work order closure rate expression is set as "([Total Closed Work Requests]/[Total Opened Work Requests])" in my table.</P><P></P><P>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% ?</P><P></P><P><IMG alt="null_field.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/142387_null_field.png" style="height: auto;" /></P></BODY></HTML> Fri, 28 Oct 2016 19:10:47 GMT https://community.qlik.com/t5/App-Development/Null-in-totals-row/m-p/1200299#M22743 2016-10-28T19:10:47Z Re: Null in totals row? https://community.qlik.com/t5/App-Development/Null-in-totals-row/m-p/1200300#M22744 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Fri, 28 Oct 2016 19:33:59 GMT https://community.qlik.com/t5/App-Development/Null-in-totals-row/m-p/1200300#M22744 2016-10-28T19:33:59Z