Rename data if.....allowing me to group up....

Post Author: Stuart

CA Forum: Formula

Dear All, I have been creating some useful reports in crystal but I can't seem to work out how to do the following. I need a statement that can do two things, If data in field 1 is equal to "100100" and data in field 2 begins with Name1 then rename "Name1" to "Name2". Essentially my data has long names and I just want to be able to group in certain ways. The above will really help me achieve this. I have tried a formula to do this but I was unsuccessful. Hope someone can assist, Many thanks, Stuart