I have a column Chart displaying average satisfaction scores month over month. There are three fields that I am looking at. However, if the customer does not fill one of the fields, it displays as 0 (even though it is null). These are messing up the averages. Is there a way to prevent certain values from being a part of the calculation without removing the entire record from being added to the average? (i.e. One survey has 10 pt for product and 0 pts for the Support agent, how do I get the 10pt for product to be included in the average, but I do not want the 0pts to be added to the support agent average)
This topic has been closed for comments
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.