AnsweredAssumed Answered

Charting - calculating field data vs blank

Question asked by HeidiEisnhauer on Apr 7, 2013
Latest reply on Apr 8, 2013 by philmodjunk


Charting - calculating field data vs blank


     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 ) )