4 Replies Latest reply: Nov 4, 2011 7:05 AM by James Edgson RSS

    Identifying & Returning Nulls

      I have a chart and I would like to display all records with a null value in my expression.  Currently the expression returns records with a value of <0, but I would also like to see nulls.  I have played around with if(IsNull...) and LEN(TRIM) have not gotten it to work yet.  Here is my current expresion, and I'm attaching a sample.  I want to list all store numbers with <= 0 cases shipped.  Does anyone know if it is possible to identify nulls in this way?   

       

      =concat({$<STORE#=>}distinct if(aggr(sum(QTY_SHIP),STORE#,[Product No])<0.001,STORE#),', ')