1 Reply Latest reply on Apr 8, 2013 8:31 AM by philmodjunk

    Charting - calculating field data vs blank

    HeidiEisnhauer

      Title

      Charting - calculating field data vs blank

      Post

           Hi :)

           Sorry if this seems simple but I have never used charting before and my issue is that my field is either listed as active or it is blank. 

           I want to represent a blank count as "inactive" without having the use the term inactive.

           Is their a simple calculation?  The below is just excluding my blanks.. which I could just simply do with T03_CONTACTS::status

           If ( IsEmpty ( Count ( T03_CONTACTS::status ) ) ; 0 ; Count ( T03_CONTACTS::status ) )
            

           Thanks,

           Heidi