Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
A formula criteria???
- Thread starter 99mel
- Start date
Use the Sum(fld,condFld,cond) function under the Summary folder in the functions list.
Inside the brackets insert the field you wish to sum in 1st, then the field that contains the information you want to sum on, and then insert the value in your conditional field where you want the sum to occur. Cheers
Marc
Inside the brackets insert the field you wish to sum in 1st, then the field that contains the information you want to sum on, and then insert the value in your conditional field where you want the sum to occur. Cheers
Marc
Marc,
I don' think using the:
Sum(fld,condFld,cond)
will help here. The condition field can only be a group field in the report, and it doesn't allow you to set a criteria.
Mel,
What you need is actually a conditional total. There are several ways to do this that are outlined in my FAQ on common formulas. This FAQ is in the Crystal General forum. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
I don' think using the:
Sum(fld,condFld,cond)
will help here. The condition field can only be a group field in the report, and it doesn't allow you to set a criteria.
Mel,
What you need is actually a conditional total. There are several ways to do this that are outlined in my FAQ on common formulas. This FAQ is in the Crystal General forum. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
- Status
Similar threads
- Locked
- Question
- Locked
- Question