crogers111
Technical User
CR XI
SQL
I have an existing crosstab report setup using the following:
Row = SvcDate (actually setup to show each row as a month)
Column = Paid/Void Date ((actually setup to show each column as a month)
Summarized Fields = Sum of Amount
Here's a simple sample of some the data:
Claim# Line# SvcDate Charge Amount Paid/Void Date
111 1 09/28/2011 100 80 10/12/2011
111 2 09/28/2011 50 40 10/12/2011
111 1 09/28/2011 -100 -80 11/04/2011
111 2 09/28/2011 -50 -40 11/04/2011
Looking at the sample data, Claim 111 was Paid on 10/12/2011 and then Voided on 11/04/2011.
Currently on the crosstabe the Paid Amount appears in the October Month Column and the Void Amount is then included in the November month column.
The client is now asking to exclude this type of data completely. In other words, if a claim is voided at a later date,
exlcude both the void and the original record from the cross tab.
Is there a way to accomplish this ? much thanks.
SQL
I have an existing crosstab report setup using the following:
Row = SvcDate (actually setup to show each row as a month)
Column = Paid/Void Date ((actually setup to show each column as a month)
Summarized Fields = Sum of Amount
Here's a simple sample of some the data:
Claim# Line# SvcDate Charge Amount Paid/Void Date
111 1 09/28/2011 100 80 10/12/2011
111 2 09/28/2011 50 40 10/12/2011
111 1 09/28/2011 -100 -80 11/04/2011
111 2 09/28/2011 -50 -40 11/04/2011
Looking at the sample data, Claim 111 was Paid on 10/12/2011 and then Voided on 11/04/2011.
Currently on the crosstabe the Paid Amount appears in the October Month Column and the Void Amount is then included in the November month column.
The client is now asking to exclude this type of data completely. In other words, if a claim is voided at a later date,
exlcude both the void and the original record from the cross tab.
Is there a way to accomplish this ? much thanks.