Group Sort Question

[crystalhelp1]

I am trying to sort a group based on a formula...

(if isnull({@QOH}) then
0
else
{@QOH}) -
((if isnull(Sum ({@Dep. Reqmnt}, {FKITMSTR.IMPN})) then
0 else
Sum ({@Dep. Reqmnt}, {FKITMSTR.IMPN})) +
(if isnull({%3 Mo. Fcst.}) then
0 else
{%3 Mo. Fcst.}))

...the formula does not show up on the "Group Sort" drop down...any ideas how I can sort on this formula field?

 

[dev1212]

drop this formula field on details section..
then right click this formula and
insert->summary ->maximum/minimum
and insert this summary on the group footer...
now you will see this in group sort expert

 

[crystalhelp1]

It doesn't give me the "Summary" option when I perform these steps. I moved to details, right clicked, clicked on Insert and all it gives me is "Field Heading". Could it have something to do with using a Sum in the formula?

 

[lbass]

You will not be able to sort on this because it already contains at least one summary (you haven't shown us the content of the nested formulas). You would have to convert all summaries contained in the formula to SQL expressions so that you can then insert a summary on the formula--which is necessary to activate the group sort.

-LB