Conditional Sum on report 
Author Message
 Conditional Sum on report

I have a table:

    FieldX        FieldY        FieldZ
    Y                    10                2
    Y                    20                3
    N                    5                  1
    N                    30                4

I want to display the sum of of (FieldY * FieldZ) where FieldX = "Y" in a
report. I don't want to Change the undelying recordset (query) because I
want to display other values which may not fall into the criteria of the
expression (ie.  SUM (FieldY * FieldZ) where FieldX = "N") on the same
report.

Probably simple but can't seem to get it. Any help will be greatly
appreciated!!

Thanks,
Joe



Sun, 16 Sep 2001 03:00:00 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Report showing BOTH Aggregate Sum of Display records and Total Sum by Group

2. Conditional Summing

3. Conditional Count ( ) or Sum ( )

4. Reporting sum in a report

5. Conditional reports

6. conditional fomatting of control text on reports

7. AM I missing something - Sum and Cumulative Sum

8. Conditional Formatting in Crystal Reports

9. conditional display of fields in Crystal Reports 7

10. Conditional Formatting in Crystal Reports

11. Conditional Suppressing on Last page of report

12. Using conditionals to print text to report

 

 
Powered by phpBB® Forum Software