2 Replies Latest reply: May 15, 2014 10:11 AM by dpetrauskas _ RSS

    Help with 'backwards' data

    dpetrauskas _

      I have an issue with the data I am extracting.  It seems the adm doc is located at the bottom with a total and I don't need the total.  I need the preceding entries to each adm doc.  Such as the first in my data is 00000 it captures the next 3 lines with 00000 and not 00004.  How would I correct this to capture the data for each adm doc correctly?

       

      CHG CD   PROC DATE    PAT ACCT   F/C   CHG P/T   ADM DOC      QTY           AMT PAID     SVC DATE   DEPT        AMT CHARGE  ZIP CODE

                                                        00000         0               0.00                                  0.00

      PAGE   2

      PBY538-2                     CHARGE SELECTION REPORT FOR DEPARTMENTS: 406

                                                        FOR THE PERIOD:  1/2010 THRU 12/2010

      CHG CD   PROC DATE    PAT ACCT   F/C   CHG P/T   ADM DOC      QTY           AMT PAID     SVC DATE   DEPT        AMT CHARGE  ZIP CODE

      26029                                                           1           3,125.59                              4,211.00

      73650                                                           0               0.00                                  0.00

      97008                                                           2           1,599.08                              1,846.00

                                                        00004         3           4,724.67                              6,056.00[/CODE]