topic Re: Adding up scheduled quantities in Collaboration with other software

Adding up scheduled quantities

Tom Krowka — Mon, 12 Jan 2015 17:13:08 GMT

See image below. Am trying to add quantites of each category together, than add the two categories together to get a grand total. Haven't had much luck.....would appreciate some advice.

Thanks Tom

Re: Adding up scheduled quantities

sinceV6 — Mon, 12 Jan 2015 17:55:41 GMT

Hello.

From what I can gather from the image:

You need to turn on the SUM option for the measured area field so that AC can add up the values and show you a grand total.

If you wish to have separate business and retail totals in the same schedule, flag the zone category (so it is listed separately), not the measured area.

Hope I understood what you need and that helps.

Re: Adding up scheduled quantities

Tom Krowka — Mon, 12 Jan 2015 19:15:33 GMT

ok....am closer. Have the grand total, now need to subtotal each category. Can't figure out how to do that. See pic below.

Re: Adding up scheduled quantities

sinceV6 — Tue, 13 Jan 2015 01:44:05 GMT

Hi.

Forgot to say (my bad) that zone category should be the first field, so that total groups by category. You will also need to check "show headline" in the schedule settings.

It is currently not grouping because all your elements are different.

Hope that solves the issue. If not, ask again

Best regards.

Re: Adding up scheduled quantities

Tom Krowka — Tue, 13 Jan 2015 19:08:22 GMT

That last clue did it. See the image below.

Thanks.