How do I conditionally filter the details data so that I can only see output below..

The Record selection formula for the whole report is this
REVERSALCODE in ["R","S"]

Current data

SRCCOD AGTID       POL      REVERSAlCODE    AMOUNT

VF      2021640     35727382     R            0
VF      2036540     35727382     R            436
VF      2036540     35727382     R            327

VF      000038624    35727445     R          4350
VF      000038624    35727445     S          -4350

VF      000002453   35727486      S           264
VF      000002436   35727486      S           456     

OUTPUT REQUIRED: Only want to see the policies that have both "R" and "S" and ignore the rest.

VF      000038624    35727445     R          4350
VF      000038624    35727445     S          -4350

Hi there thanks for the explanation of the formulas.

It worked like a charm.

Edited by Nav522 - 12 Apr 2018 at 5:32am