SUM same record values?

[vikoch]

I have a Table with columns (amounts):
amt1
amt2
amt3
amt4

I need to select and print the line (for same record)where:

amt1 >= 5 and amt2 >=5 and amt3 >= 5 and amt4 >= 5 and sum of (amt1, amt2, amt3, amt4) >=30

Is it possible to do this in Crystal? If it is, please help me.
Ira.

 

[lbass]

Try adding this in report->selection formula->GROUP:

amt1 >= 5 and
amt2 >=5 and
amt3 >= 5 and
amt4 >= 5 and
sum ([amt1, amt2, amt3, amt4]) >=30

-LB