Sorting based on Group formula

[DrHabi]

The formula below is needed to calculate my Cost of Goods. The problem I am having is trying to sort by lowest t highest. This formula is in my grouping as you can see. If you have ay suggestions that would be great.

IF Sum ({@Credits}, {ZETUP08.dept6}) > 0 then
100 *Sum ({@Debits}, {ZETUP08.dept6}) / Sum ({@Credits}, {ZETUP08.dept6})

 

[Parkypark]

If you have a value produced by this formula, you should be able to sort lowest to highest

you will need to highlight the filed in design view and select the GROUP SORT EXPERT
you can then select the grouping to decending or assending

hope this is what you need
Rich