Trouble with conditional sum

[Almie]

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

 

[kray4660]

So what is the question?

 

[pmax9999]

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

 

[Almie]

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??

 

[AndyMc]

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.

 

[Almie]

I found my answer!! I excluded using the Change Group option . Whoohoo!!