when uisng the convert to formula funciton in BEx it messes up other colums

when I try to use this functionality I have formatting issues and some of the data in my columsn gets lost. when I try to user the Filter button it gets even worse. We are on the Support pack 15 so this is not the issue. Any ideas why this isn't working?