Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Group by with negative values
Message
 
 
À
03/03/2011 11:31:27
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01502506
Message ID:
01502517
Vues:
41
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform