This could be due to several reasons. It is possibly related to the way the formula was written or the data type. It will be good if you can move this question from here and ask it as a new question. This will make the question appear in the unanswered section, making it visible to everyone? Also it it will be good if you can attach a sample data to the question.