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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trouble with conditional sum

Status
Not open for further replies.

Almie

Technical User
Nov 28, 2006
39
US
I am using Crystal 10. I am trying to get a sum amount of only specific detail items. Here is an example
990 case_master_caa44340 - include in sum
234 party_name_master_caa44240 - include in sum
45 party_address_assoc_caa83040 - include in sum
55 party_address_master_caa49140 - include in sum
101 motor_type - exclude from sum
45 motor_qualifier_code_caa39840 - exclude from sum
66 motor_prefix_caa56540 - exclude from sum
10 probs_caa38440 - exclude from sum

 
What is the logic behind this. On what basis are the records included or excluded?

 
Sorry....I should expand....
These records fall under several different groups...
Case
990 case_master_caa44340 - include in sum
Party
234 party_name_master_caa44240 - include in sum
45 party_address_assoc_caa83040 - include in sum
55 party_address_master_caa49140 - include in sum
Motor
101 motor_type - exclude from sum
45 motor_qualifier_code_caa39840 - exclude from sum
66 motor_prefix_caa56540 - exclude from sum
Prob
10 probs_caa38440 - exclude from sum

How do I exclude the records and the groups: Motor and Prob??
 
If you want to leave the motor and prob records out of the report all together, in Record Selection formula:
not({yourGroupField} in ["Prob","Motor"])

If you want to leave them in the report but get a sum without prob and motor, create a formula:

{@yourFormula}:
if not({yourGroupField} in ["Prob","Motor"]) then {yourNumericField} else 0

put this formula in detail section and sum it.

 
I found my answer!! I excluded using the Change Group option . Whoohoo!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top