Skip to main content
Question

Formula to combine subtotals for one type

  • Jan 18, 2022 5:56 AM UTC
  • 0 replies
  • 66 views

Report displayed as below -

(Field 1) Stage               Field 2) Type              (Field 3) Subtotal
Temp Services              Material                       $500
Temp Services              Labour                         $100
Power                             Material                       $200
Power                             Labour                         
Cable                              Material                      $100
Cable                              Labour                         $200

What I need is a field that will -
1. Only show the stage once
2. Combine the subtotals for the stage

So the output would be -
(Field 1) Stage                            (Field 3) Subtotal
Temp Services                                     $600
Power                                                    $200                            
Cable                                                    $300

------------------------------
Jessica Matenga
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
No problem, the report type you are currently using is called a table report. That is just a list of records.
Make a brand new report but this time choose report type  Summary. It will let you configure which field(s) to total and it will let you group by the Stage.

The report will allow users to drill down into the detail that makes up the totals. If you'd like you can show a count of the number of underlying records as part of the summary report.


------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------