Forum Discussion

RebeccaKnecht__'s avatar
RebeccaKnecht__
Qrew Member
2 years ago

Exporting totals

Is there a way to take the total of multiple entries like it shows in the report and get those to export to excel or into another report. 

The break down is an expense report is created, within this report are multiple weeks, each week has its own weekly total. I want to then get the total of all weeks for that expense report only.



Full Report  Grid Edit  Email  More 3 Expense Report Week records
 
Employee Name
Week
Date
Month
Location
Hotel
Expenses
Per Diem
Flat Rate
Mileage
Mileage Cost
Total
(Dollars)
Mileage Cost
Total 2
Mileage Cost
Total 3
Toll
Misc Cost
Misc Comments
Daily
Total
Weekly Total
Pay back
Reviewed
Reviewed on:
Reviewed by:
Weekly
Total
 
Knecht, MS,  ACSM-CEP, Rebecca 1 11-14-2022 November 2022 Palm Coast   $70.00   50 $20.47 $0.585 $8.77 $2.20     $92.67 $263.68       $263.68
Knecht, MS,  ACSM-CEP, Rebecca 2 11-20-2022 November 2022 Contra Costa $1,125.00 $150.00             $35.00 Uber $185.00 $585.00       $1710.00
Knecht, MS,  ACSM-CEP, Rebecca 3 11-22-2022 November 2022 Tampa       35 $11.70       $60.00 Ink $71.70 $71.70       $71.70
TOT           $1,125.00 $220.00 $0.00 85 $32.17 $0.585 $8.77 $2.20 $95.00   $349.38 $920.38       $2045.38


------------------------------
Rebecca Knecht, MS, ACSM-CEP
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    I suggest that you make a new report of type "Summary" and it will let you export its lines, which will be the totals.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------