I have a field called status that can essentially have three answers: Canceled, No Response, or it can be left blank. I have a found set of 15 records. Four of the records have "No Response", one "Canceled", and the remaining ten are blank. Ultimately I want to calculate the percentage of events responded to.
Here is what I have done. I have a field that says what the event type is. I have the report in a list. I have a field in the Grand Summary that gives me a sum of count of the count of the event type (lets just say "Meeting"). I have the result of 15, since there were 15 records.
I am having trouble extracting the number of "No Response" and the "Canceled" from my from my status field.
I am not sure if I should be making Global Fields, or what to do. I have tried using Values, and Count