You're welcome
>Thank you, that works.
>
>
>
>>Yes, group by ID, Credit and SIGN(Amount)
>>
>>>I have a table with this structure and values:
>>>ID Amount Credit
>>>1 15 .F.
>>>1 10 .F.
>>>2 10 .F.
>>>2 -5 .T.
>>>2 5 .T.
>>>2 25 .F.
>>>
>>>I would like to Sum the Amount column and group by ID and Credit. But I want to show negative and positive values separately, so I also want to group on negative or positive.
>>>
>>>I would like this as a result: Is this possible?
>>>ID Amount Credit
>>>1 25 F
>>>2 35 F
>>>2 -5 T
>>>2 5 T
>>>
>>>
--sb--