Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Building a conditional sum.
Message
De
24/12/1998 05:30:06
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentine
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Building a conditional sum.
Divers
Thread ID:
00170185
Message ID:
00170185
Vues:
56
Hi all,

I need to build a conditional SUM and I want to include it in a Report.
I have the following instruction that works in an SQL statement but not like a fixed field at report´s feet.

SUM(IIF(a.myCond = .T.,a.myOption1,a.myOption2)) AS n_amount.

Thanks for your help
Thanks in advance
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform