Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group Sort Question

Status
Not open for further replies.

crystalhelp1

Technical User
Aug 21, 2010
19
US
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?
 
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
 
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?
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top