topic Schedule of Zone areas to show Sub Totals not Grand Totals in Documentation

Schedule of Zone areas to show Sub Totals not Grand Totals

Josh Verran — Tue, 19 Oct 2021 21:46:28 GMT

I have various schedules set up to read the Areas of zones, broken up by zone category (eg Buildings and Decks).

I need to see the total area of buildings and also the total areas of Decks.

I don't want to see the total area of buildings and decks combined.

I have tried various combinations withing the schedules but not having any luck.

In the past, I have made the Grand total white, but seems a bit low-tech and has its own issues.

Any suggestions?

Re: Schedule of Zone areas to show Sub Totals not Grand Totals

Barry Kelly — Wed, 20 Oct 2021 01:55:26 GMT

If you are summing and using the flag to group values, I don't think there is any way to have a sub-total without a grand-total.

However in the format settings, try selecting the grand total and making the row height very small, and/or the font small and white pen.

That might hide it.

Barry.

Re: Schedule of Zone areas to show Sub Totals not Grand Totals

Liamthanks — Wed, 20 Oct 2021 22:59:21 GMT

You could categorize the zones and have 2 seperate schedules, one for building and the other for decking.

Re: Schedule of Zone areas to show Sub Totals not Grand Totals

gdford — Tue, 27 Sep 2022 23:17:48 GMT

Great Idea Barry - this has drove me nuts for years...

Re: Schedule of Zone areas to show Sub Totals not Grand Totals

Karl Ottenstein — Wed, 28 Sep 2022 00:56:27 GMT

Somewhat risky if the number of zones changes, but I’ve typically cropped the placed schedule on the layout to crop off the grand total. If Barry’s idea works, it would be a better option as the full schedule would always display even as the number of zones changes and or you change other formatting.