If-then-else statements in crosstabs

[envirodata]

Using Crystal Reports for BlackBaud, Version 8.5.
I am attempting to write a formula for a cross-tab and insert it as a row. The first step I took was to open the formatting box and hit New Formula. I used this formula (which had no errors):

If {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong} = "Activist" Then " Individual Donor " Else {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong} ;
If {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong} = " Prospect " Then " Individual Donor " Else {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong};
If {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong} = "Member" Then "Individual Donor" Else {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong};
If {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong} = " Staff " Then " Individual Donor " Else {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong};
If {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong} = " Advocacy Contact " Then " Individual Donor " Else {GfCnCnstncy_1.GfCnCnstncy_1_CodeLong}

Finally, I inserted the formula as a row. However, after doing so, the text Member, Staff, etc. was not replaced by Individual Donor but remained as Member, Staff, etc. Did I put this formula in the wrong place? Any suggestions?

Thank you!

 

[SkipVought]

Hi,

This is not a CR forum, rather MS Access.

Check out the forums for CR, lkie forum149.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[envirodata]

Right. Thank you. Have posted elsewhere.