Group Sort Expert

Does anyone know what allows fields to appear in the group sort expert, while others are not available as options?

I am working on a report in Crystal 2008. I have one grouping which I need to have sorted descending by a formula in the report; however the formula is not available in the “based on” drop down box.

Even when I take one of the fields that is in the dropdown box and put the same formula in a new test variable, the test variable is not available as a sorting option.

Any help understanding how the group sort expert works would be greatly appreciated.


idw2ty (BOB member since 2009-05-06)