Skip to Content
0
Former Member
Oct 23, 2012 at 03:20 PM

Conditional formula combining two rows of data

19 Views

Hi all,

I have a report where I need to display like shown below,

Person Agent New contracts Used contracts Policy XYZ A 120 100 W/I ABC A 12 40 I CDE B 30 80 W

But My data is,

Person Agent New contracts Used contracts Policy XYZ A 60 50 I ABC A 12 40 I CDE B 30 80 W XYZ A 60 50 W

If a person pariticipates in both the policies, then add the contracts from both the policies and display "W/I", else display the one policy he is participating.

Thanks