1 Reply Latest reply: Dec 4, 2018 7:31 PM by Chris Porthouse RSS

    Trying to add a column of data that is not in line with the rest of my data...anyone know how?

    Sissy_0209 _

      I have a report where one column of data is not in the same format as the rest of the data.  There are two lines (typically) one for the Invoice total and one for the location total.  We pick up location total for our spreadsheets.  "Location Total:  00097" (Typical data) then for this one particular state, we have a line that states SPD Total  Is there a way to make this a column that I cannot figure out?   The "SPD" is another column and you can see that there is a complete separate line for the amount that should be SPD, but I cannot figure out how to add this as a column in Monarch along with the rest of my data.  I am using version 11.1...Thanks for any assistance!


                           ___I_N_V_O_I_C_E___      ------ G R O S S ------       --------------- T A X E S ---------------     T O T A L    CC            

                           Number      mmddyyyy        EXEMPT       TAXABLE       STATE      COUNTY        CITY     TRANSIT     T A X E S  TYPE            





      INVOICE TOTAL:       0000000008  02252018     126558.25    123151.23   111315.39      112.43-   76398.31        5.90     310758.40 


      **LOCATION TOTAL: 00097                       126558.25    123151.23   111315.39      112.43-   76398.31        5.90     310758.40                  


      INVOICE TOTAL:       0000000008  02252018     71563.33    330937.20   14297.94      15.10-   67884.23      129.20-    82040.24                  


      SPD TOTALS :     Unknown                                                                                  2.37-                                      


      **LOCATION TOTAL: 00098                       271563.33    3430937.20   14297.94       15.10-   67884.23      129.20-   82040.24                  


      SPD TOTALS :     Unknown                                                                                  2.37-