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..
LVL 1
wshcraft70Asked:
Who is Participating?
 
mlmccConnect With a Mentor 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
0
 
peter57rConnect With a Mentor 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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.