Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Building a conditional sum.
Message
From
24/12/1998 05:30:06
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentina
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Building a conditional sum.
Miscellaneous
Thread ID:
00170185
Message ID:
00170185
Views:
54
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
Next
Reply
Map
View

Click here to load this message in the networking platform