The following statement works great in 7.6.10 in Windows 2003 server.

RANKED BY HIGHEST 10 TOTAL CAR_DAYS
PLUS OTHERS AS 'All Others'

We are testing 7.7.03 in Windows 2008 server, and the above statement generates (FOC715) BY TOTAL AND PLUS OTHERS CAN'T BE USED TOGETHER.

Is there any new simple replacement statement to accomplish the same functionalities as above?

This message has been edited. Last edited by: Kerry,

Apart from shifting the CAR_DAYS from a compute to a define, or holding the data, so you can remove the TOTAL, then probably not.