We help IT Professionals succeed at work.

Crystal Formula Assistance required

I need to do something like this..

Sum({CallDetail.Duration})  if {CallDetail.InternalNum} Not in range of 600 - 699

I don't know how to pull out the range..
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Use a running totals field, starting from field explorer.

Specify the Sum of the Duration field;
Evaluate using a formula which would be..

{CallDetail.InternalNum}<600 or {CallDetail.InternalNum} >699

If this is a single total for the report you don't reset; if it's a total per group then you need to Reset on change of group.
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
ANother way would be

If {CallDetail.InternalNum}<600 or {CallDetail.InternalNum} >699 then
     {CallDetail.Duration}
Else
     0

You can then summarize the formula

mlmcc

Explore More ContentExplore courses, solutions, and other research materials related to this topic.