More details are required before we can effectively help. Specifically, more details about the steps leading up to the formula: field names, field types, example output, screenshots, etc. The more details you can provide the easier it’ll be to help. The formula looks good on the surface, which is why I feel that the problem lies in some step before the formula.
