Got myself a stupid problem, but i guess (hope) there a easy sollution

 

I have grouped my detail on a field called artcode

 

in my detailed i have for every artcode some value's if there was a stock mutation on that article / value of that item @ that moment / ...  in a given time period (parameter on date field)

 

now i get somthing like this

 

 

group:    volgnr          Totmutations           TotValue

detail:     volgnr          stockmutation          Value

 

Becouse there are sometimes more then 1 mutation on a article during a time period (for example there is -1 on a article but couple days later they find it back and they do a +1 on that stock possition of that article) i have to group on volgnr

 

in the end i get somthing like this

 

volgnr     totmutation     TotValue

300561         -2                  -15€

300681          3                    75€

306857        -11                -120€

...

 

you get the picture

 

now i would like to sort this list on the TotValue field but when i try to select that formula in the record sort expert (the A-Z symbol) it's not availeble.

I understand why it's not availeble as the totvalue is only calculated in the group and not in the detail so i can't record sort on it.

 

But what to do then ?

 

Hope somebody know a way arround.

 

Tnx in advance

 

Adam Field

 

I can select the value field now (remade it so it's a calculated field from the detail line.

 

I can now select the field in my detail sort expert but that doesn't change a thing.

It sorts the value's now in every group

i can't put it higher on the list eather in the sort expert.

 

The group goos first then the value

 

Adam