Have a field in a group that I would like to sort descending. The field includes formulas (see below). Basically the field is looking for the gross profit per lb for the group #2. The report is grouped by salesman then by customer. It would be great to then have the values sorted descending so the values are in a sensible order. The group sort expert is not an option since this formula is 'after the hump' . Is there a 'whileprintingrecords' command that needs to be inserted to allow for sorting or do I need to export and manually sort in Excel? Thoughts.
if Sum ({invdth.idhswt}, {invdth.idhcid}) = 0 then 0 else
{@grp2margindiffavg}/Sum ({invdth.idhswt}, {invdth.idhcid})
if Sum ({invdth.idhswt}, {invdth.idhcid}) = 0 then 0 else
{@grp2margindiffavg}/Sum ({invdth.idhswt}, {invdth.idhcid})