0 Replies Latest reply: Feb 15, 2012 4:19 AM by Abraham Deme RSS

    Display NullCount(Expression)  values

    Abraham Deme

      Hi everyone,

       

      I have a slight problem and wondered if you lovely people can help me out here. I'm using the below if statement to display 3 options in a list box:

      1. Display accounts with multiple write offs  (identified by their installation number)

      2. Display accounts with single write offs

      3. Display accounts where somehow there was a write-off but for some odd reasons, the installation is coming up as Null

       

      if(count(distinct Installation) = 1 AND count(distinct Document_Number) >1 AND Installation <> '','Multiple Write Offs Accounts',

         if(count(distinct Installation) = 1 AND  count(distinct Document_Number)= 1, 'Single Write Offs Accounts',

          if(NullCount(Installation), 'Write offs where Installation is null' ))) as Write_Off_Segmentation

       

       

      The first two work absolutely fine, it's just the 3rd option will only bring a count of one and no data show up. It is recognising something since, the option does come up in the list box.

       

       

      Note: When i use NullCount(Installation) in a chart box expression, it does bring the values. So please help me out.

       

      Thanks in advance.