A workflow rule with workflow action of field update is active but is not giving the desired
result. What could be the reason?

Answer: There might be another active workflow rule on the same object which might be giving an output which is conflicting with the output of this workflow rule by updating the same field in some other way. De activate the other workflow rule or check the business logic as to why we are doing multiple field updates on the same field.