Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Building a conditional SUM
Message
From
23/12/1998 22:00:20
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentina
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Building a conditional SUM
Miscellaneous
Thread ID:
00170147
Message ID:
00170147
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.plan,a.val_cuot,a.amount)) AS n_amount.

TIA
Thanks in advance
Next
Reply
Map
View

Click here to load this message in the networking platform