I can't get a column to provide a total using the Grouping Reporter

[Martrice Denson]

I have a reporting table where I'm trying to summary a column by grouping information.  The grouped numbers in the are fine but I can't get the column to total properly.

For the summary column I have tried  Summary Type = Sum, and Summary Value =

%grouped:data:status1% 

Status1 is the data field name.

<ac:structured-macro ac:macro-id="18299bf2-c611-45c2-a7c4-4fac023578bd" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="e021020a-bb6f-4140-856b-5555d0ea28ff" ac:name="grouping-reporter" ac:schema-version="1">
      <ac:parameter ac:name="as">Industry</ac:parameter>
      <ac:parameter ac:name="">data:industry</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="9ca9aa5a-8c2d-46df-8389-ef1c75740b04" ac:name="local-reporter" ac:schema-version="1">
          <ac:parameter ac:name="">data&colon;applications</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:structured-macro ac:macro-id="acf091da-85da-4334-8e79-911ab1a645fb" ac:name="text-sort" ac:schema-version="1">
                <ac:parameter ac:name="">data:industry</ac:parameter>
              </ac:structured-macro>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p>
          <ac:structured-macro ac:macro-id="36819d79-35de-463d-8c38-f426accf2055" ac:name="grouping-stats" ac:schema-version="1">
            <ac:parameter ac:name="as">status1</ac:parameter>
            <ac:parameter ac:name="">data:status1</ac:parameter>
          </ac:structured-macro>
        </p>
        <p>
          <ac:structured-macro ac:macro-id="126ec9d2-4d00-48f2-9ee6-0230d32e7d70" ac:name="grouping-stats" ac:schema-version="1">
            <ac:parameter ac:name="as">status</ac:parameter>
            <ac:parameter ac:name="">data:status</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="e79b62c3-bdd6-4c6f-a0b2-eea832c2dd00" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Industry</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="9fc2ded4-c3a7-48f3-b864-ce8804c51ba0" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="render">wiki</ac:parameter>
            <ac:parameter ac:name="">grouped:Industry</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="e04d6d36-e20d-400f-a375-33cb9a094444" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="summaryType">sum</ac:parameter>
      <ac:parameter ac:name="injected">true</ac:parameter>
      <ac:parameter ac:name="summaryValue">%grouped:data:status1%</ac:parameter>
      <ac:parameter ac:name="title">Draft</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="7f13385e-ebbc-4240-abf5-7101f4a4ab1f" ac:name="report-block" ac:schema-version="1">
          <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:macro-id="c909427f-a977-43c2-9205-cf2e2f8dd90a" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">grouped:@items</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="fc61c725-7a4a-4147-9ab4-3cf51cbfd589" ac:name="and-filter" ac:schema-version="1">
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="6095deeb-2b0b-48fa-b81b-e6fe7ac6576d" ac:name="text-filter" ac:schema-version="1">
                        <ac:parameter ac:name="include">.*Draft.*</ac:parameter>
                        <ac:parameter ac:name="">data:status1</ac:parameter>
                      </ac:structured-macro>
                    </p>
                    <p>
                      <br/>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
                <p>
                  <ac:structured-macro ac:macro-id="a93d2c02-4d98-429f-9f78-7565119780a8" ac:name="text-sort" ac:schema-version="1">
                    <ac:parameter ac:name="">data:Industry</ac:parameter>
                  </ac:structured-macro>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="8fc4e7a8-d7e5-412f-a2d8-ae4fe67fcf0f" ac:name="report-header" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <ac:structured-macro ac:macro-id="4c0a6e7c-92f4-4a5b-9182-f125c38e6b27" ac:name="report-info" ac:schema-version="1">
                    <ac:parameter ac:name="render">richtext</ac:parameter>
                    <ac:parameter ac:name="">report:query&gt;size</ac:parameter>
                  </ac:structured-macro>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="197c12a8-d5fe-4e79-becb-1ef89a8394db" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <br/>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="22036bf6-5955-4662-b248-eaf4b289bb60" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="summaryType">sum</ac:parameter>
      <ac:parameter ac:name="summaryValue">%grouped:data:status1%</ac:parameter>
      <ac:parameter ac:name="title">Handoff</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="d3031a1f-98dc-4e7a-8c29-fda529128d07" ac:name="report-block" ac:schema-version="1">
          <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:macro-id="55ba1c88-996e-49e2-ae3a-f1aa60597157" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">grouped:@items</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="f26c3833-c8f6-4ff3-af22-dc52b814caf5" ac:name="and-filter" ac:schema-version="1">
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="24753948-ad89-4258-894f-56c5221af087" ac:name="text-filter" ac:schema-version="1">
                        <ac:parameter ac:name="include">.*Handoff.*</ac:parameter>
                        <ac:parameter ac:name="">data:status1</ac:parameter>
                      </ac:structured-macro>
                    </p>
                    <p>
                      <br/>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="fd177653-f390-4fec-8350-ed5ab243b8cc" ac:name="report-header" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <ac:structured-macro ac:macro-id="0222732a-817f-4949-833c-cf37ce9f40bf" ac:name="report-info" ac:schema-version="1">
                    <ac:parameter ac:name="">report:query&gt;size</ac:parameter>
                  </ac:structured-macro>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="e36c4471-2190-47cc-9739-a70fc27ac50a" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <br/>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
        <p>
          <br/>
        </p>
        <p>
          <br/>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="4787081a-6346-49f9-a1ed-34bf3f7981d9" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">In Dev</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="f6d5ce4e-0656-4a54-88ed-dec7bb9e3c1d" ac:name="report-block" ac:schema-version="1">
          <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:macro-id="9b86b4a3-56f2-4121-8843-4f9010cd6bf5" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">grouped:@items</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="a1826cb6-4bb7-4aed-b247-f3ad7b22f02e" ac:name="and-filter" ac:schema-version="1">
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="ece94b5a-acfa-4c77-a760-5768704d3136" ac:name="text-filter" ac:schema-version="1">
                        <ac:parameter ac:name="include">.*In Dev.*</ac:parameter>
                        <ac:parameter ac:name="">data:status</ac:parameter>
                      </ac:structured-macro>
                    </p>
                    <p>
                      <br/>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="aa164291-a3fd-4c6e-a183-60e29c884020" ac:name="report-header" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <ac:structured-macro ac:macro-id="11f34653-45fa-448f-b688-e43e6d3578bf" ac:name="report-info" ac:schema-version="1">
                    <ac:parameter ac:name="">report:query&gt;size</ac:parameter>
                  </ac:structured-macro>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="37bbe919-7ce1-463e-9eb2-b826866f9b9f" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <br/>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="42654c41-a348-4f91-98ea-4bcd9b23831e" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Completed</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="98631d39-29db-44b2-8eeb-8d34a100e5ea" ac:name="report-block" ac:schema-version="1">
          <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:macro-id="3ebd645a-b5e9-471c-94c9-31fbf616ccd5" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">grouped:@items</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="97f0b8f5-79b4-4eb1-a36e-9d5622b67ce7" ac:name="and-filter" ac:schema-version="1">
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="9e91d0e1-112a-456b-84cf-f1412f8ff5f6" ac:name="text-filter" ac:schema-version="1">
                        <ac:parameter ac:name="include">.*Completed.*</ac:parameter>
                        <ac:parameter ac:name="">data:status</ac:parameter>
                      </ac:structured-macro>
                    </p>
                    <p>
                      <br/>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="e94a95cd-ff38-4698-a951-6702a82569e3" ac:name="report-header" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <ac:structured-macro ac:macro-id="d5c2ed6b-147f-4553-a6c4-b21797cbe7bc" ac:name="report-info" ac:schema-version="1">
                    <ac:parameter ac:name="">report:query&gt;size</ac:parameter>
                  </ac:structured-macro>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="341d5157-409c-438b-ba05-d8e96ffbd738" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <br/>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p>
      <br/>
    </p>
    <p>
      <br/>
    </p>
    <ac:structured-macro ac:macro-id="340b3a6b-94ef-4faf-a7d8-c7f6fe4f0afb" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Canceled</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="1c5c9913-500d-4f92-a2aa-13c24fabd45e" ac:name="report-block" ac:schema-version="1">
          <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:macro-id="5d67371f-d84c-4e00-b656-e6d5cd285023" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">grouped:@items</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="6d094469-3004-4179-a928-2424c2ad698b" ac:name="and-filter" ac:schema-version="1">
                  <ac:rich-text-body>
                    <p>
                      <ac:structured-macro ac:macro-id="45a4f187-3d2d-460f-bd7e-43d5b14d5f77" ac:name="text-filter" ac:schema-version="1">
                        <ac:parameter ac:name="include">.*Canceled.*</ac:parameter>
                        <ac:parameter ac:name="">data:status</ac:parameter>
                      </ac:structured-macro>
                    </p>
                    <p>
                      <br/>
                    </p>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="6e0c0335-1332-45e1-aa1f-6886755c22b3" ac:name="report-header" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <ac:structured-macro ac:macro-id="312d0735-aa28-4320-b331-88cf6c901d04" ac:name="report-info" ac:schema-version="1">
                    <ac:parameter ac:name="">report:query&gt;size</ac:parameter>
                  </ac:structured-macro>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
            <ac:structured-macro ac:macro-id="b5b88412-6323-4ec2-9df3-e2fe49a66221" ac:name="report-body" ac:schema-version="1">
              <ac:rich-text-body>
                <p>
                  <br/>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p>
      <br/>
    </p>
    <p>
      <br/>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
<hr/>