Summary conditional 1

[Bentk]

I need to summarize at field conditionally in crystal 8

I need to summarize all the feild "sales" based on this
where column a=1 and column b=1 then summarize all "sales" rows where that condition is met

I don't want to summarize the "sales" feild where a=1 and b=3

Thanks in advance,

Bentk

 

[kskid]

[ol][li]If that is the only summary you are totalling, then include the condition in your record selection formula. Then all you have to do is summarize the sales field.[/li]
[li]Or you could use a running total and use the formula option to set the condition[/li]
[li]Or you could create 3 three formulas[/li]

//Initialize variable and place in report header
shared numbervar totsales := 0;

//accumulate sales
shared numbervar totsales;
if {table.columna} = 1 and {table.columnb} = 1 then
totsales := totsales + {table.salesfield}
else totsales := totsales;

//Display total sales
shared numbervar totsales;
totsales

[/ol]

-LW

 

[synapsevampire]

IF you only want those values in the report, then filter all others out by using the Report->Edit Selection Formula-Record and place:

(
{table.columna}=1
and
{table.columnb}=1
)

If you want the other data in the report, but need tailored summaries for just that condition, insert a running total and in the Evaluate->Use a Formula place:

(
{table.columna}=1
and
{table.columnb}=1
)

-k

 

[Bentk]

Thanks you all for the help. This worked like a champ.

Bentk