I have a scenario where I have to suppress the entire row based on a condition. I'm not sure how to write that but posting it here for some assistance.

Here is the data and want to bring only those records if the reversal happened on the same Date. For Example

Agent ABC2 has a -$10 reversal for the Date 6/20

Policy   AgentID Reversalcode DATE Amt

123       ABC2                   5/20   10
123       ABC2                   5/20   10   
123       ABC2          R        6/20   -10
123       ABC2                    6/20   10
123       ABC2                    7/20    30
123       ABC2                     8/20    40
456        XYZ3          R        1/20   -50
456        XYZ3                   1/20     50

I was using {next} function on the Date to suppress but its suppressing every time there is a date change regardless of the policy.

have to suppress only with in a given policy.

Output:

123       ABC2          R        6/20   -10
123       ABC2                     6/20   10
456        XYZ3          R        1/20   -50
456        XYZ3                     1/20   50




Edited by Nav522 - 01 Feb 2017 at 1:52pm

This is going to be only suppressing no calculations needed in the Footer.

That didn't work. Looks like I have some of the rows with Zero Amounts and this is what it returned

Real Data:
123       ABC2                   5/20   10
123       ABC2                   5/20   10    
123       ABC2          R        6/20   -10
123       ABC2                    6/20   10
123       ABC2                    6/20   0
123       ABC2           R        6/20   0
123       ABC2                    7/20    30
123       ABC2                     8/20    40


Output returned after using the Suppression formula
123       ABC2           R        6/20   0
123       ABC2                     6/20   0

I should only see these records

123       ABC2          R        6/20   -10
123       ABC2                    6/20   10

Added the table.amt <> 0 condition in each part and now the detail section is completely suppressed no data.

I noticed I haveent used Date in either of the parts. Should I use that too?

Thank you. Let me try that.