I am trying to do a nested if statement in Crystal Reports.
I have 3 company names based on a company id, so if id=1 then "company A" if id=2 then "company B" else "company C" but I can't get it to work, I get an error when saving the formula that "The remaining text does not appear to be part of the formula" and it highlights everything after my first variable. Can anyone show me the proper syntax for this formula. I am completely new to sql