The appropriate answer to this is "No, it wasn't" to show agreement with the speaker. Question tags are used to elicit agreement from a listener and therefore the most appropriate response should be one of agreement.