Formula to combine subtotals for one type

Question

Report displayed as below -(Field 1) Stage&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Field 2) Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (Field 3) SubtotalTemp Services&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Material&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$500Temp Services&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Labour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100Power&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Material&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$200Power&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Labour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Material&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $100Cable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Labour&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$200What I need is a field that will -1. Only show the stage once2. Combine the subtotals for the stageSo the output would be -(Field 1) Stage&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (Field 3) SubtotalTemp Services&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$600Power&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Cable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $300------------------------------Jessica Matenga------------------------------

markshnier__you · Answer

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.

jessicamatenga · Answer

Hi MarkThe report is fine, I need the fields so that I can pull the combined data into exact forms.&nbsp; At the moment it is listing it like the report, itemised but yes I would like a summary as above if this can be done.------------------------------Jessica Matenga------------------------------

markshnier__you · Answer

Sorry but I don't have an answer for you.&nbsp;
I am not sure if you were talking about native Exact forms or the Exact Forms Plus Add On from Juiced. &nbsp; But either way I don't have a great answer.&nbsp;
I don't think it can be done with the juiced add-on and while I'm not an expert on need of exact forms, I believe you can only use a table report configuration for the query there as well so I think that won't work either.
grasping at straws a bit it might be possible to push a button on see an order, I will assume that these are some kind of customer order documents, &nbsp;And put focus on the order. Then you would have summary fields that would summarize back up to the table where the stage is come from to put the summary totals up there and then the exact form would be generated off that summary table.&nbsp;
But I think they would take some one on one consulting to try to coax that to work.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

jessicamatenga · Answer

Thank you Mark------------------------------Jessica Matenga------------------------------

Forum Discussion

Formula to combine subtotals for one type