Report Sum of Scaffold data

  • 1
  • Question
  • Updated 2 years ago
  • (Edited)
Folks,
I have multiple pages with Scaffold tables reporting financial figures. I want calculate the total cost of all of these without using a report table, I just want to see the total figure. I gone through many community posts and looked at Stats-on and Report-eval but I don't know how to resolve this.

If anyone can help I would really appreciate it. We are running Conf 5.10.4, Scaffolding 8.7.5 & Reporting 6.4.5.


<ac:layout>  <ac:layout-section ac:type="single">
    <ac:layout-cell>
      <p>
        <ac:structured-macro ac:macro-id="4cdacc41-99da-45bb-a929-6e269b3610b6" ac:name="report-on" ac:schema-version="1">
          <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
          <ac:parameter ac:name="">grouped:@items</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:structured-macro ac:macro-id="ae94daea-9f15-4f8e-b88b-a872e35e8b59" ac:name="report-info" ac:schema-version="1">
                <ac:parameter ac:name="">expanded:DateTable&gt;data:edu_rev_cost</ac:parameter>
              </ac:structured-macro> at <ac:structured-macro ac:macro-id="4a578630-ac54-4649-a986-3a75e008a77f" ac:name="report-info" ac:schema-version="1">
                <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
                <ac:parameter ac:name="">expanded:DateTable&gt;data:DateField</ac:parameter>
              </ac:structured-macro>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
      </p>
    </ac:layout-cell>
  </ac:layout-section>
  <ac:layout-section ac:type="single">
    <ac:layout-cell>
      <ac:structured-macro ac:macro-id="c2f23a03-abb1-41c5-82b6-dd4810647015" ac:name="report-table" ac:schema-version="1">
        <ac:rich-text-body>
          <ac:structured-macro ac:macro-id="747c0f1c-4ed6-4f25-81c0-c9e2218c68f8" ac:name="grouping-reporter" ac:schema-version="1">
            <ac:parameter ac:name="as">Month</ac:parameter>
            <ac:parameter ac:name="">expanded:DateTable&gt;data:Sales</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="81dbd046-85cf-48cc-b18f-d7e5481225a5" ac:name="grouping-stats" ac:schema-version="1">
                  <ac:parameter ac:name="as">cost</ac:parameter>
                  <ac:parameter ac:name="">data:edu_rev_cost</ac:parameter>
                </ac:structured-macro>
              </p>
              <ac:structured-macro ac:macro-id="c80a6a94-d668-4cef-9e91-6776fab283f3" ac:name="expanding-reporter" ac:schema-version="1">
                <ac:parameter ac:name="as">DateTable</ac:parameter>
                <ac:parameter ac:name="">data:gsap1</ac:parameter>
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="5304f5f0-22b8-4ec7-ad09-0402e3d7f83e" ac:name="local-reporter" ac:schema-version="1">
                    <ac:parameter ac:name="source">GSA:Alliances</ac:parameter>
                    <ac:parameter ac:name="">page:sorted descendents</ac:parameter>
                    <ac:rich-text-body> </ac:rich-text-body>
                  </ac:structured-macro>
                  <p>
                    <ac:structured-macro ac:macro-id="b968de65-b826-4bf1-8022-0d32adaa2821" ac:name="text-sort" ac:schema-version="1">
                      <ac:parameter ac:name="">data:Sales</ac:parameter>
                    </ac:structured-macro>
                  </p>
                </ac:rich-text-body>
              </ac:structured-macro>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="d8605e00-b334-44a8-b6ac-5f01d4c07a4f" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Month</ac:parameter>
            <ac:rich-text-body>
              <p>
                <ac:structured-macro ac:macro-id="e546857b-995b-48ff-9225-f17a9f683da6" ac:name="report-info" ac:schema-version="1">
                  <ac:parameter ac:name="render">wiki</ac:parameter>
                  <ac:parameter ac:name="">grouped:Month</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="9d9b3a33-ee13-4fa2-b5ee-9efb876bc9de" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Details</ac:parameter>
            <ac:rich-text-body>
              <p>Count: <ac:structured-macro ac:macro-id="49c900e0-93bd-4027-ae26-f78ac8a5735a" ac:name="report-info" ac:schema-version="1">
                  <ac:parameter ac:name="">grouped:@items&gt;size</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="880cfb9d-fdfa-4261-a922-cb1a6805b508" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Sum</ac:parameter>
            <ac:rich-text-body>
              <p>Sum: <ac:structured-macro ac:macro-id="4ef15d18-ade8-4d7d-8be4-31e60864e8f8" ac:name="report-info" ac:schema-version="1">
                  <ac:parameter ac:name="format">$##0.00</ac:parameter>
                  <ac:parameter ac:name="">grouped:@items &gt; stats-on:"data:edu_rev_cost &gt; collection:size " &gt; stats:sum</ac:parameter>
                </ac:structured-macro>
              </p>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="5a373b4a-e294-497f-81e3-08e039cd4f60" ac:name="report-column" ac:schema-version="1">
            <ac:parameter ac:name="title">Sum 2</ac:parameter>
            <ac:rich-text-body>
              <p>Stat Sum:</p>
              <ac:structured-macro ac:macro-id="57a1ec29-2412-4e7d-9810-451833c99f57" ac:name="report-eval" ac:schema-version="1">
                <ac:parameter ac:name="format">$##0.00</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
                <ac:parameter ac:name="">DelayPeriod</ac:parameter>
                <ac:plain-text-body><![CDATA[%data:edu_rev_cost-Sum%]]></ac:plain-text-body>
              </ac:structured-macro>
            </ac:rich-text-body>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="4814b719-275d-49cd-b3db-7a6bae95e832" ac:name="report-empty" ac:schema-version="1">
            <ac:rich-text-body>
              <p>No results to report</p>
            </ac:rich-text-body>
          </ac:structured-macro>
        </ac:rich-text-body>
      </ac:structured-macro>
      <p> </p>
      <p> </p>
      <p>
        <ac:structured-macro ac:macro-id="b1e77a19-8cfb-45da-a64c-6f63b91cd855" ac:name="report-info" ac:schema-version="1">
          <ac:parameter ac:name="">page:children &gt; stats-on:data:Costing &gt; stats:sum</ac:parameter>
        </ac:structured-macro>
      </p>
      <p> </p>
    </ac:layout-cell>
  </ac:layout-section>
</ac:layout>

Photo of Con

Con

  • 17 Posts
  • 0 Reply Likes
  • frustrated

Posted 2 years ago

  • 1
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Con,

From the storage format you provided above, we realize that we will require more information to look into your inquiry. 
 
Could you please reach out to us at our Support channel : support@servicerocket.com

It would be great if you can share the storage format of the Scaffolding data when you get back to us.

Thank you.

Regards,
Suresh
(Edited)