Conditional summaries

[davidrobin]

I need to do a conditional summary.

i.e. Only count if value is "EEE". I don't think there is a way to do it. Does anyone know of any work around.



David
Visual Basic 6 Ent

 

[kphu]

David,

Try this in a formula.

whilereadingrecords;
numbervar x;
if fieldname = "EEE" then x = 1 else


After you save the formula create a sum of this formula and place it in a group.

Example.

Report format

Report Header
Page Header
GroupHeader - Place the sum of x formulat here.
details
groupfooter.

Ken

 

[kchaudhry]

Another approach would be to create a formula like this:

@formula name:

if {table.yourfield} = "EEE"
then 1 esle 0

Now create a summary for this formula.

Kchaudhry