summary report needs one type condition

[Former Member]

I have a summary report which has this data:

transcode     count

001              10

WOC           12

MOC            14

we have making up the orders that are summarized many order_types.

For the 001 transcode, we only want to process a specific order_type, RTR.

so i have in a formula not sure how to tell it to reject if cond. is not met.

I created a view whihc has this condition of 001 and RTR. this would maybe be easier sort of formula.

IF {CLSPAYTP.OTTRNC} = '001'

and {CLSPAYTP.OHORDT} = 'RTR'

then

[former_member292966 · Accepted solution]

Hi Paul,

Is this a Record Selection Formula you want or a formula to do the summary?

If it's a Record Select Formula then it would look something like:

Select {CLSPAYTP.OTTRNC}

     Case '001' :{CLSPAYTP.OHORDT} = 'RTR'

      Default :{CLSPAYTP.OTTRNC} <> '001';

If it's a formula for summing then:

If {CLSPAYTP.OTTRNC} = "001" And {CLSPAYTP.OHORDT} = "RTR" then

     1

Else if {CLSPAYTP.OTTRNC} <> "001" Then

     1;

Drop this into the Detail section and do a Sum on it.  This should give you the count you need.

Adding it to your Record Selection would be easier.  You could just do a Count now on a field on the detail section.  No extra coding required.

Hope this helps,

Brian