I have several 'Times Contacted' fields that are banded into ranges and I am determining what the indexes are for those people who are Do Not Contacts versus those who are not (to determine what is the over/under on # of contacts). I have the following Set Analysis statement to figure out what the index is:
(SUM({$<Do_Not_Contact={'Y'}>} Customer_Counter) / SUM({$<Do_Not_Contact={'Y'}>} TOTAL Customer_Counter)) / (SUM({$<Do_Not_Contact={'N'}>} Customer_Counter) / SUM({$<Do_Not_Contact={'N'}>} TOTAL Customer_Counter)) * 100
This works great on the 'Overall Times Contacted' table because every record has a dimensional value of at least 1. However, when I get to vertical-specific report (ie Times Contacted VM) I have dimensions that are NULL because they may not have been contacted via phone. How should I modify my Set Analysis to knock out those NULL values, as they skew my results?
So, if I had three distinct fields (one VM, one DM, and one EM) I would then need three distinct tables holding 'N' values for each one individually, correct?
