1 Reply Latest reply: May 3, 2016 1:42 PM by Olly Bond RSS

    Need help with a Monarch 12.0.1.1 report

    alewis _

      I have a text file that looks like this:

       

      DEPARTMENT 0203 CCICU 665 W
                                   THIS MONTH                YEAR-TO-DATE                  THIS MONTH LAST YEAR    YEAR-TO-DATE LAST YEAR
                              NUMBER         AMOUNT    NUMBER          AMOUNT             NUMBER         AMOUNT    NUMBER          AMOUNT
      ____________________________________________________________________________________________________________________________________
              00249922 OBSERV-FIRST HR
      INPATIENT                    1         345.00         3        1,035.00
      OUTPATIENT                   3       1,035.00         8        2,744.00                  3         987.00         5        1,645.00

      TOTAL                        4       1,380.00        11        3,779.00                  3         987.00         5        1,645.00
      ____________________________________________________________________________________________________________________________________
              00249923 OBSERV-ADDL HRS
      INPATIENT                   47       4,230.00       141       12,690.00
      OUTPATIENT                  45       4,050.00       147       13,226.00                 70       6,020.00       107        9,202.00

      TOTAL                       92       8,280.00       288       25,916.00      

       

      DEPARTMENT 0203 CCICU 665 W
                                   THIS MONTH                YEAR-TO-DATE                  THIS MONTH LAST YEAR    YEAR-TO-DATE LAST YEAR
                              NUMBER         AMOUNT    NUMBER          AMOUNT             NUMBER         AMOUNT    NUMBER          AMOUNT

       

      I need to make this into a text file that has the "price" calculated for both the Inpatient & Outpatient, Year to Date lines. I have that data trapped & the price calculated.  The output that I need to create needs to look like this:

      _

      203 ,249922 ,1,   345.00

      203 ,249922 ,2,   343.00

      203 ,249923 ,1,    90.00

      203 ,249923 ,2,    89.97

      Where the fields are Department, Charge Code, Inpatient=1 or Outpatient=2, Price

       

      Is there a way to do this?  I'm have no idea how to get report to make the lines for the Inpatient & Outpatient (1 & 2) data.

      Thanks

      _________________________________________________________________________________________________________________________________