the brackets are working fine in the rest of the formual. I only get the err msg when I add the "order by" clause.

The err msg is from Crystal...shows my formula and at the end says:

remaining text does not appear to be part of the formula