Charting - calculating field data vs blank
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 ) )
Count ( T03_CONTACTS:://some nevery empty field ) - Count ( T03_CONTACTS::status )
should count the number of related records in T03_Contacts where status is blank.