Need to use scaffold data local to page and in another page

  • 1
  • Question
  • Updated 2 years ago
  • (Edited)
I need to do a report-eval (multiplication of two values) on a value in a table local to the current page and a value retrieved by a reporter.

On a page, I want to calculate the cost associate with the number of FTE's required for a certain task. (FTE=Full Time Employee)

I have a table on a page called a Rate Table.  This table is a data-table that contains Rates for FTE's per each Fiscal Year.  On the child pages of another page are scaffold form that indicate how many FTEs are required per fiscal year.  I need to multiply these two together.

So far, I have tried capturing the value in a variable (which doesn't seem to work for a filtered report giving a single number result).  with a report eval of %data:CostperFY% * %variable:Rates%

However the variable Rates doesn't seem to pull results from the table outside the current reporter. (again, the Rate table is on the same page, containing two columns FY and Rate).

Thanks for any help!
Katy
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes

Posted 2 years ago

  • 1
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Kathryn,

From your inquiry, looks like we will require more information. 
 
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 and Reporting when you get back to us.

Thank you.

Regards,
Suresh
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
I replied to Support and I will post the code here.
This is the page that is doing the calculation.
<code>
<h2>Rate Table</h2>
<p> </p>
<ac:structured-macro ac:macro-id="079b2ad2-4301-4d2a-9c58-83bad0a8f0e3" ac:name="table-data" ac:schema-version="1">
  <ac:parameter ac:name="name">RateTable</ac:parameter>
  <ac:rich-text-body>
    <table>
      <tbody>
        <tr>
          <th>
            <p style="text-align: center;">FY</p>
          </th>
          <th colspan="1" style="text-align: center;">Rate</th>
        </tr>
        <tr>
          <td>
            <ac:structured-macro ac:macro-id="10fd1935-0536-411c-bf16-ea4de0e9a714" ac:name="list-data" ac:schema-version="1">
              <ac:parameter ac:name="name">FY</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="564984af-6330-4688-a141-3aefab9d2304" 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="86a73daa-1d2e-487b-9770-b39e0ce42d6e" ac:name="local-reporter" ac:schema-version="1">
                      <ac:parameter ac:name="source">OrionPPC:Form Dropdowns for TLO</ac:parameter>
                      <ac:parameter ac:name="">data:FiscalYears</ac:parameter>
                      <ac:rich-text-body>
                        <p> </p>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                    <ac:structured-macro ac:macro-id="9a8d37a0-f1b4-4ba0-ad32-5bbd58dc5ce4" ac:name="report-body" ac:schema-version="1">
                      <ac:parameter ac:name="injected">true</ac:parameter>
                      <ac:rich-text-body>
                        <ac:structured-macro ac:macro-id="c8710aa9-2d13-45dd-88c6-72a92516e58f" ac:name="list-option" ac:schema-version="1">
                          <ac:parameter ac:name="sortValue">%data:FieldOrder%</ac:parameter>
                          <ac:parameter ac:name="value">%data:FiscalYearsSelect%</ac:parameter>
                          <ac:rich-text-body> </ac:rich-text-body>
                        </ac:structured-macro>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
          </td>
          <td colspan="1">
            <p>
              <ac:structured-macro ac:macro-id="33eee96c-21cb-47c6-aee9-a186dd01b645" ac:name="number-data" ac:schema-version="1">
                <ac:parameter ac:name="format">#0.#</ac:parameter>
                <ac:parameter ac:name="name">Rate</ac:parameter>
                <ac:parameter ac:name="decimal">true</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:plain-text-body><![CDATA[ ]]></ac:plain-text-body>
              </ac:structured-macro>
            </p>
          </td>
        </tr>
      </tbody>
    </table>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <ac:structured-macro ac:macro-id="81c120ae-627c-4ba0-ad8f-c21924e3b420" ac:name="report-variable" ac:schema-version="1">
    <ac:parameter ac:name="name">Rates</ac:parameter>
    <ac:parameter ac:name="value">%data:Rate%</ac:parameter>
    <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
    <ac:rich-text-body>
      <p> </p>
    </ac:rich-text-body>
  </ac:structured-macro>
  <ac:structured-macro ac:macro-id="72a874c9-e0f6-498c-a91e-5a9562b3eb7c" ac:name="report-info" ac:schema-version="1">
    <ac:parameter ac:name="">variable:Rates</ac:parameter>
  </ac:structured-macro>
</p>
<h3>Non-Prime FTE Liens &amp; Threats</h3>
<ac:structured-macro ac:macro-id="5fbb3dee-e3ab-485b-a35c-9c707e36d6bc" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="5831a4a7-eb3f-4ade-a4d1-4035925ab28c" ac:name="local-reporter" ac:schema-version="1">
      <ac:parameter ac:name="source">TLO List</ac:parameter>
      <ac:parameter ac:name="">page:children</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="519dc1b6-b337-4089-beb5-c086fdda66a1" ac:name="text-filter" ac:schema-version="1">
            <ac:parameter ac:name="value">Non-Prime</ac:parameter>
            <ac:parameter ac:name="">data:PrimeNonPrime&gt;first</ac:parameter>
          </ac:structured-macro> <ac:structured-macro ac:macro-id="8677366c-6b0d-41e8-b493-3a987714ce8c" ac:name="text-filter" ac:schema-version="1">
            <ac:parameter ac:name="include">.*FTE.*</ac:parameter>
            <ac:parameter ac:name="">data:ProcFTE</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="f0ab58ec-07a0-446f-9e62-8667d366b156" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Status</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="33d1fc7b-5046-4dd7-bf37-fd70aee06e06" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:Lifecycle</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="aa4e81a6-ea6c-40f3-92d2-ce22118b0e8a" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">TLO #</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="da18aa84-6df9-43f8-861f-0e5e68d55b4a" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">page:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="272327c9-e34f-4243-b105-af511be2ad9b" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">TLO Title</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="e61207c9-6ea3-496e-bd2e-86c148613c3a" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:TLOTitle&gt;text:first 50</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="5b640b38-9e93-4a9c-ba01-3321dbe7717e" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="width">150px</ac:parameter>
      <ac:parameter ac:name="title">Description</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="b952012e-06d5-44c3-b135-c2ae1aa9ffb9" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="render">richtext</ac:parameter>
            <ac:parameter ac:name="">data:Description&gt;text:first 100</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="031149f1-a541-4923-87e5-a0ee1af667e8" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">CAM</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="d81c0eaf-8e3a-4cc4-a282-d0ad545b6b88" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:CAM</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="bd9d0bc3-bbe4-4742-b288-6661160258f2" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Cost Threat/Lien/Opportunity</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="174e22e7-e992-4aaf-b914-a150650084d5" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:TLO</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <br/>
    <ac:structured-macro ac:macro-id="129dc3f0-fe84-497f-903b-a22c91dbe5f6" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">FY16</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="cb52fe41-7195-4e90-bda1-4930d2c704a8" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">variable:Rates</ac:parameter>
          </ac:structured-macro>
          <ac:structured-macro ac:macro-id="def89dba-1b5d-41ed-b04e-f648625b7f87" ac:name="report-eval" ac:schema-version="1">
            <ac:parameter ac:name="default">0</ac:parameter>
            <ac:parameter ac:name="format">#,##0.00</ac:parameter>
            <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
            <ac:plain-text-body><![CDATA[%data:CostperFY% * %variable:Rates%]]></ac:plain-text-body>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
</code>

The calculation of data:CostperFY * variable:Rates is not working.

I have tried also not using a variable but that isn't working.

Katy
Photo of André

André

  • 7 Posts
  • 0 Reply Likes
Hi Katy
What works for me:
{report-table}
{local-reporter:page:children:source=TLO List}
{local-reporter}
{report-variable:name=vCoxtperFY:value=0%data:CostperFY%:default=0}
{report-variable:name=vRates:value=0%data:Rate%:default=0}
{report-eval:name=eCalc:default=0:format=0.00}
((%variable:vCoxtperFY%)*(%variable:vRates%))
{report-eval}
{report-table}

This is "only" the raw-structure
Hope this helps
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
Thanks for your help!  When I put the report variables outside of the local reporter, I get errors.  This was a new "fix" Service Rocket put in lately when they got rid of some outdated code.  If I put them in the column I still get an error.
I appreciate you trying, however!  If you have more advice, just let me know.

Also, is it a typo that your report-variable has value =0%data:xxx%?  I assumed the zero was a typo.
Thank you!
Katy
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Kathryn,

It would be great if you can share the storage format of the Scaffolding forms so that we will be able to assist you better. 

If the information is confidential, could you please reach out to us at our Support channel : support@servicerocket.com

Thank you.

Regards,
Suresh
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
Sorry I left that out.  Here is the form storage format.
<code>
<ac:structured-macro ac:macro-id="a54d5115-48aa-48d4-8a5d-4830d65b43ea" ac:name="table-plus" ac:schema-version="1">
  <ac:parameter ac:name="enableHeadingAttributes">false</ac:parameter>
  <ac:parameter ac:name="columnAttributes">width=25%,width=20%,width=25%,width=30%</ac:parameter>
  <ac:parameter ac:name="enableSorting">false</ac:parameter>
  <ac:parameter ac:name="enableHighlighting">false</ac:parameter>
  <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
  <ac:rich-text-body>
    <table>
      <tbody>
        <tr>
          <th colspan="4">
            <h1 style="text-align: center;">Cost Threats, Liens, Opportunities</h1>
          </th>
        </tr>
        <tr>
          <th style="text-align: right;">Tracking #</th>
          <td>
            <p>
              <ac:structured-macro ac:macro-id="dce0035e-c5eb-4e9f-ac5f-aaa4dff02143" ac:name="report-info" ac:schema-version="1">
                <ac:parameter ac:name="1">@self</ac:parameter>
                <ac:parameter ac:name="">page:title</ac:parameter>
              </ac:structured-macro>
            </p>
          </td>
          <th style="text-align: right;">Title</th>
          <td colspan="1">
            <p>
              <ac:structured-macro ac:macro-id="fa6b54d9-a7e4-4b92-bf21-0774a0c7d835" ac:name="text-data" ac:schema-version="1">
                <ac:parameter ac:name="name">TLOTitle</ac:parameter>
                <ac:parameter ac:name="width">95%</ac:parameter>
                <ac:parameter ac:name="type">line</ac:parameter>
                <ac:parameter ac:name="content">text</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:rich-text-body> </ac:rich-text-body>
              </ac:structured-macro>
            </p>
          </td>
        </tr>
        <tr>
          <th colspan="1" style="text-align: right;">Prime/Non-Prime</th>
          <td colspan="1">
            <p>
              <ac:structured-macro ac:macro-id="cc662dfc-61b7-476e-8974-af13ae747da9" ac:name="list-data" ac:schema-version="1">
                <ac:parameter ac:name="name">PrimeNonPrime</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="23651b0d-74b8-4919-8890-8fbbf5ee2d3e" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">1</ac:parameter>
                    <ac:parameter ac:name="value">Non-Prime</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="296a29ee-da10-40c7-b6a3-aaebb9649233" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">2</ac:parameter>
                    <ac:parameter ac:name="value">Prime</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                </ac:rich-text-body>
              </ac:structured-macro>
            </p>
          </td>
          <th colspan="1" style="text-align: right;">Status</th>
          <td colspan="1">
            <p>
              <ac:structured-macro ac:macro-id="2b92dbcb-d447-4dc4-944a-51b9da28e46d" ac:name="list-data" ac:schema-version="1">
                <ac:parameter ac:name="blank">false</ac:parameter>
                <ac:parameter ac:name="name">Lifecycle</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="fbdfe0d4-7d49-40d9-ab66-8f9096f77cb2" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">1</ac:parameter>
                    <ac:parameter ac:name="value">Open</ac:parameter>
                    <ac:rich-text-body>
                      <p>Open</p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="fb219f52-c206-4d4c-aa35-964514f6b314" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">2</ac:parameter>
                    <ac:parameter ac:name="value">Closed</ac:parameter>
                    <ac:rich-text-body>
                      <p>Closed</p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                </ac:rich-text-body>
              </ac:structured-macro>
            </p>
          </td>
        </tr>
        <tr>
          <th colspan="1" style="text-align: right;">CAM</th>
          <td>
            <ac:structured-macro ac:macro-id="2cbb05e8-36ea-4b16-ad37-336408a5fe1f" ac:name="list-data" ac:schema-version="1">
              <ac:parameter ac:name="name">CAM</ac:parameter>
              <ac:parameter ac:name="separator">newline</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="b168cc5f-74a6-4588-b36a-273e517ba504" 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="ee3186cb-9c41-496b-b5ec-906f7d20a537" ac:name="local-reporter" ac:schema-version="1">
                      <ac:parameter ac:name="source">OrionPPC:Form Dropdowns for TLO</ac:parameter>
                      <ac:parameter ac:name="">data:CAM</ac:parameter>
                      <ac:rich-text-body>
                        <p> </p>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                    <ac:structured-macro ac:macro-id="b4829bbd-7853-4e29-8ee9-05a9b56b766d" ac:name="report-body" ac:schema-version="1">
                      <ac:parameter ac:name="injected">true</ac:parameter>
                      <ac:rich-text-body>
                        <ac:structured-macro ac:macro-id="421cfc44-a5d2-4614-83b5-14fd46fc8780" ac:name="list-option" ac:schema-version="1">
                          <ac:parameter ac:name="value">%data:CAMSelect%</ac:parameter>
                          <ac:rich-text-body> </ac:rich-text-body>
                        </ac:structured-macro>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
          </td>
          <th style="text-align: right;">Cost Threat/Lien/Opportunity</th>
          <td>
            <ac:structured-macro ac:macro-id="068a10ca-a083-4d65-b4af-468980d0ea63" ac:name="list-data" ac:schema-version="1">
              <ac:parameter ac:name="name">TLO</ac:parameter>
              <ac:parameter ac:name="separator">newline</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="a7137415-d923-4ebf-b643-65e76de45b7e" 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="9babc36e-5429-4f1f-892a-b2ccad714fe7" ac:name="local-reporter" ac:schema-version="1">
                      <ac:parameter ac:name="source">OrionPPC:Form Dropdowns for TLO</ac:parameter>
                      <ac:parameter ac:name="">data:TLOList</ac:parameter>
                      <ac:rich-text-body>
                        <p> </p>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                    <ac:structured-macro ac:macro-id="eee10f8d-4a30-47f6-8225-c59acb8cb6e8" ac:name="report-body" ac:schema-version="1">
                      <ac:parameter ac:name="injected">true</ac:parameter>
                      <ac:rich-text-body>
                        <ac:structured-macro ac:macro-id="907943dd-f1e8-4bed-a62f-8a02e0e24de0" ac:name="list-option" ac:schema-version="1">
                          <ac:parameter ac:name="sortValue">%data:FieldOrder%</ac:parameter>
                          <ac:parameter ac:name="value">%data:TLOSelect%</ac:parameter>
                          <ac:rich-text-body> </ac:rich-text-body>
                        </ac:structured-macro>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
          </td>
        </tr>
        <tr>
          <th colspan="1" style="text-align: right;">Description</th>
          <td colspan="3">
            <p>
              <ac:structured-macro ac:macro-id="43f16588-39d8-4903-b17a-d5e870f7e24b" ac:name="text-data" ac:schema-version="1">
                <ac:parameter ac:name="name">Description</ac:parameter>
                <ac:parameter ac:name="width">90%</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:parameter ac:name="height">100px</ac:parameter>
                <ac:rich-text-body>
                  <p> </p>
                </ac:rich-text-body>
              </ac:structured-macro>
            </p>
          </td>
        </tr>
        <tr>
          <th colspan="1" style="text-align: right;">WAD/ECR<br/>(Prime Only)</th>
          <td>
            <p>
              <ac:structured-macro ac:macro-id="5f3701f8-4dba-4f31-a0ca-24bc1d61ee34" ac:name="list-data" ac:schema-version="1">
                <ac:parameter ac:name="name">WadEcr</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="137180fc-e09c-4b90-b11a-bc4192adc21d" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">1</ac:parameter>
                    <ac:parameter ac:name="value">WAD</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="52f734e6-17ba-433d-aaea-4bb680aaf018" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">2</ac:parameter>
                    <ac:parameter ac:name="value">ECR</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="55792d70-0a89-48ff-8599-10e34719ec57" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">3</ac:parameter>
                    <ac:parameter ac:name="value">Proc</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                </ac:rich-text-body>
              </ac:structured-macro>
            </p>
          </td>
          <th style="text-align: right;">Level</th>
          <td>
            <p>
              <ac:structured-macro ac:macro-id="9580760f-6b97-464c-b1c7-18a50ac42f80" ac:name="list-data" ac:schema-version="1">
                <ac:parameter ac:name="name">Level</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="d6456425-c29b-42d2-94e0-f7bed91f5651" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">1</ac:parameter>
                    <ac:parameter ac:name="value">H</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="237b79c8-ba74-4c2d-baec-412fa97df1cf" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">2</ac:parameter>
                    <ac:parameter ac:name="value">M</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="8e0f7d75-c21a-4477-bcb2-3602e8a11260" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">3</ac:parameter>
                    <ac:parameter ac:name="value">L</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                </ac:rich-text-body>
              </ac:structured-macro>
            </p>
          </td>
        </tr>
        <tr>
          <th colspan="1" style="text-align: right;">Proc / FTE<br/>(Non-Prime Only)</th>
          <td colspan="1">
            <p>
              <ac:structured-macro ac:macro-id="46ceb9a3-84ab-4480-bed3-b905987f49c3" ac:name="list-data" ac:schema-version="1">
                <ac:parameter ac:name="blank">false</ac:parameter>
                <ac:parameter ac:name="name">ProcFTE</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="97a89f65-fc0d-46fb-baed-228461e52c24" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">1</ac:parameter>
                    <ac:parameter ac:name="value">Proc</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="a5bd25b9-67b3-4fb0-b7c5-083280a1b3a8" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">2</ac:parameter>
                    <ac:parameter ac:name="value">FTE</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                </ac:rich-text-body>
              </ac:structured-macro>
            </p>
          </td>
          <th colspan="1" style="text-align: right;">Type</th>
          <td colspan="1">
            <p>
              <ac:structured-macro ac:macro-id="d57e6314-7e6b-4c13-b556-dcbb5903a911" ac:name="list-data" ac:schema-version="1">
                <ac:parameter ac:name="name">TLOType</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="ecf26248-170a-4934-8e15-31b6c1e119a2" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">1</ac:parameter>
                    <ac:parameter ac:name="value">DD</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="66ee3349-6369-40bb-8788-4777892e5b43" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">2</ac:parameter>
                    <ac:parameter ac:name="value">Process</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="6b533875-d64f-4f17-8986-ead3fdc8acc6" ac:name="list-option" ac:schema-version="1">
                    <ac:parameter ac:name="sortValue">3</ac:parameter>
                    <ac:parameter ac:name="value">Mgmt</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                </ac:rich-text-body>
              </ac:structured-macro>
            </p>
          </td>
        </tr>
        <tr>
          <th colspan="1" style="text-align: right;">Cost/FY Tracking</th>
          <td colspan="3">
            <ac:structured-macro ac:macro-id="77f6d0dc-37b6-4fb5-a59e-c7a66282737b" ac:name="table-data" ac:schema-version="1">
              <ac:parameter ac:name="name">CostTracking</ac:parameter>
              <ac:rich-text-body>
                <table>
                  <tbody>
                    <tr>
                      <th style="text-align: center;">FY</th>
                      <th style="text-align: center;">Cost ($M)/FTE</th>
                    </tr>
                    <tr>
                      <td>
                        <ac:structured-macro ac:macro-id="390d5a4b-8723-4a87-a108-6aab4e7c689e" ac:name="list-data" ac:schema-version="1">
                          <ac:parameter ac:name="name">FY</ac:parameter>
                          <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
                          <ac:rich-text-body>
                            <ac:structured-macro ac:macro-id="5dfd8c8c-e71f-4255-bafd-50aecf755c70" 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="8203b706-99f6-4404-ad6e-7f0714a93a28" ac:name="local-reporter" ac:schema-version="1">
                                  <ac:parameter ac:name="source">OrionPPC:Form Dropdowns for TLO</ac:parameter>
                                  <ac:parameter ac:name="">data:FiscalYears</ac:parameter>
                                  <ac:rich-text-body>
                                    <p> </p>
                                  </ac:rich-text-body>
                                </ac:structured-macro>
                                <ac:structured-macro ac:macro-id="d7b8f8c6-dca2-4ef2-95d9-fee43e2e91ff" ac:name="report-body" ac:schema-version="1">
                                  <ac:parameter ac:name="injected">true</ac:parameter>
                                  <ac:rich-text-body>
                                    <ac:structured-macro ac:macro-id="fff78966-3f84-48aa-9798-c1e4a96489f1" ac:name="list-option" ac:schema-version="1">
                                      <ac:parameter ac:name="sortValue">%data:FieldOrder%</ac:parameter>
                                      <ac:parameter ac:name="value">%data:FiscalYearsSelect%</ac:parameter>
                                      <ac:rich-text-body> </ac:rich-text-body>
                                    </ac:structured-macro>
                                  </ac:rich-text-body>
                                </ac:structured-macro>
                              </ac:rich-text-body>
                            </ac:structured-macro>
                          </ac:rich-text-body>
                        </ac:structured-macro>
                      </td>
                      <td>
                        <p>
                          <ac:structured-macro ac:macro-id="7697ab36-2ec3-468f-bdd3-3e5d6925fa40" ac:name="number-data" ac:schema-version="1">
                            <ac:parameter ac:name="name">CostperFY</ac:parameter>
                            <ac:parameter ac:name="decimal">true</ac:parameter>
                            <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                            <ac:plain-text-body><![CDATA[ ]]></ac:plain-text-body>
                          </ac:structured-macro>
                        </p>
                      </td>
                    </tr>
                  </tbody>
                </table>
              </ac:rich-text-body>
            </ac:structured-macro>
          </td>
        </tr>
        <tr>
          <th colspan="1" style="text-align: right;">
            <ul>
              <li>Explain Any Changes from Previous Report (i.e. Funded, Mitigated, Decreased Value, etc.)<span style="color: rgb(255,0,0);">*<br/>Required</span>
              </li>
            </ul>
          </th>
          <td colspan="3">
            <p>
              <ac:structured-macro ac:macro-id="9b058b59-74d2-4f5a-87e9-5a364c15e0ff" ac:name="text-data" ac:schema-version="1">
                <ac:parameter ac:name="name">Trace</ac:parameter>
                <ac:parameter ac:name="width">90%</ac:parameter>
                <ac:parameter ac:name="required">true</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:parameter ac:name="height">150px</ac:parameter>
                <ac:rich-text-body>
                  <p> </p>
                </ac:rich-text-body>
              </ac:structured-macro>
            </p>
          </td>
        </tr>
      </tbody>
    </table>
  </ac:rich-text-body>
</ac:structured-macro></code>
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
Anything new on this?
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
Anything new?  I need a solution, please.  Or at least I need to know that it will not work and why.  Thank you.
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
Is this not going to work?  Please reply.
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
HI Kathryn, 

Excuse us for the delayed reply. 

Albeit a little, I can understand the frustration over the loss of function at work due to this.

We are still investigating if its possible. We will get back to you once we have restructured your storage format. 

Regards,
Suresh
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
Thanks for the reply!
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
It has been a month, any luck with this?
Thanks!
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
What has happened to Service Rocket?  You guys used to be so responsive.  Please answer this issue!
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Kathryn,

Excuse us for the delayed reply. 

Due to the complexity of the reporting structure, we will need more time to work on this. 

Moving forward, I will be sure to give you an update every two days on the progress. 

Thank you.

Regards,
Suresh
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Kathryn,

To test the functionality of report-eval properly on our test instance, can you please share the following page's storage format with us :

  • OrionPPC:Form Dropdowns for TLO
  • TLO List
The reason why we need both of the pages as we can see that the storage format you shared with us are pulling data from both the pages.

Thank you.

Regards,
Suresh
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
Thank you!  TLO List has no content.  It is just the parent page for all of the pages that have content.
The Form Dropdowns page contains table-data's that are used to provide the elements for the list-data's.  
Neither of these has content related to my question.  
I have simplified the code to help illustrate.  Sorry for the confusing complexity.
<code>
<h2>Rate Table</h2>
<p> </p>
<ac:structured-macro ac:macro-id="079b2ad2-4301-4d2a-9c58-83bad0a8f0e3" ac:name="table-data" ac:schema-version="1">
  <ac:parameter ac:name="name">RateTable</ac:parameter>
  <ac:rich-text-body>
    <table>
      <tbody>
        <tr>
          <th>
            <p style="text-align: center;">FY</p>
          </th>
          <th colspan="1" style="text-align: center;">Rate</th>
        </tr>
        <tr>
          <td>
            <ac:structured-macro ac:macro-id="10fd1935-0536-411c-bf16-ea4de0e9a714" ac:name="list-data" ac:schema-version="1">
              <ac:parameter ac:name="name">FY</ac:parameter>
              <ac:parameter ac:name="atlassian-macro-output-type">BLOCK</ac:parameter>
              <ac:rich-text-body>
                <ac:structured-macro ac:macro-id="564984af-6330-4688-a141-3aefab9d2304" 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="86a73daa-1d2e-487b-9770-b39e0ce42d6e" ac:name="local-reporter" ac:schema-version="1">
                      <ac:parameter ac:name="source">OrionPPC:Form Dropdowns for TLO</ac:parameter>
                      <ac:parameter ac:name="">data:FiscalYears</ac:parameter>
                      <ac:rich-text-body>
                        <p> </p>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                    <ac:structured-macro ac:macro-id="9a8d37a0-f1b4-4ba0-ad32-5bbd58dc5ce4" ac:name="report-body" ac:schema-version="1">
                      <ac:parameter ac:name="injected">true</ac:parameter>
                      <ac:rich-text-body>
                        <ac:structured-macro ac:macro-id="c8710aa9-2d13-45dd-88c6-72a92516e58f" ac:name="list-option" ac:schema-version="1">
                          <ac:parameter ac:name="sortValue">%data:FieldOrder%</ac:parameter>
                          <ac:parameter ac:name="value">%data:FiscalYearsSelect%</ac:parameter>
                          <ac:rich-text-body> </ac:rich-text-body>
                        </ac:structured-macro>
                      </ac:rich-text-body>
                    </ac:structured-macro>
                  </ac:rich-text-body>
                </ac:structured-macro>
              </ac:rich-text-body>
            </ac:structured-macro>
          </td>
          <td colspan="1">
            <p>
              <ac:structured-macro ac:macro-id="33eee96c-21cb-47c6-aee9-a186dd01b645" ac:name="number-data" ac:schema-version="1">
                <ac:parameter ac:name="format">#0.#</ac:parameter>
                <ac:parameter ac:name="name">Rate</ac:parameter>
                <ac:parameter ac:name="decimal">true</ac:parameter>
                <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                <ac:plain-text-body><![CDATA[ ]]></ac:plain-text-body>
              </ac:structured-macro>
            </p>
          </td>
        </tr>
      </tbody>
    </table>
  </ac:rich-text-body>
</ac:structured-macro>
<p>
  <ac:structured-macro ac:macro-id="81c120ae-627c-4ba0-ad8f-c21924e3b420" ac:name="report-variable" ac:schema-version="1">
    <ac:parameter ac:name="name">Rates</ac:parameter>
    <ac:parameter ac:name="value">%data:Rate%</ac:parameter>
    <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
    <ac:rich-text-body>
      <p> </p>
    </ac:rich-text-body>
  </ac:structured-macro>
<ac:structured-macro ac:macro-id="36b7d4ae-5644-4984-b318-2351c0fc324c" ac:name="report-table" ac:schema-version="1">  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="73ef4cb9-86af-4c1e-8400-d7c99fe7be4c" ac:name="local-reporter" ac:schema-version="1">
      <ac:parameter ac:name="source">TLO List</ac:parameter>
      <ac:parameter ac:name="">page:children</ac:parameter>
      <ac:rich-text-body>
        <p> </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="d21b4a69-51ef-4e6b-a8e6-d8ecf844d4c8" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">TLO #</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="22388019-f4f3-4b76-a131-a20c9962a4e8" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">page:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="867e5f03-3b96-4a47-bc6b-7e27f32e5ea7" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">FY17</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="ceb3a705-f7f7-4073-a67f-32694b16b7bf" ac:name="report-block" ac:schema-version="1">
            <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
            <ac:rich-text-body>
              <ac:structured-macro ac:macro-id="3c27568b-2e83-4d86-9ce0-00f8850e1cbd" ac:name="expanding-reporter" ac:schema-version="1">
                <ac:parameter ac:name="as">CostTracking</ac:parameter>
                <ac:parameter ac:name="">data:CostTracking</ac:parameter>
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="e1d4ba7b-2412-47ee-8922-fd0f56edc304" ac:name="local-reporter" ac:schema-version="1">
                    <ac:parameter ac:name="source">@self</ac:parameter>
                    <ac:parameter ac:name="">page:children</ac:parameter>
                    <ac:rich-text-body>
                      <p> </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <p>
                    <ac:structured-macro ac:macro-id="c619e32a-9b7b-41d8-b87e-1b088bea2242" ac:name="text-filter" ac:schema-version="1">
                      <ac:parameter ac:name="include">.*FY17.*</ac:parameter>
                      <ac:parameter ac:name="">data:FY&gt;first</ac:parameter>
                    </ac:structured-macro>
                  </p>
                </ac:rich-text-body>
              </ac:structured-macro>
              <ac:structured-macro ac:macro-id="f72b8cd1-70f9-423d-a5ab-5d74bd1b6119" ac:name="report-body" ac:schema-version="1">
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="c9c391c9-ce8f-4db2-8153-77badd7892f4" ac:name="report-eval" ac:schema-version="1">
                    <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                    <ac:plain-text-body><![CDATA[%CostTracking>data:CostperFY% * %variable:CostTable%]]></ac:plain-text-body>
                  </ac:structured-macro>
                </ac:rich-text-body>
              </ac:structured-macro>
            </ac:rich-text-body>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro></code>

hope this helps!
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Kathryn,

Thank you for the storage format. 

We will get back to you with our findings. 

Regards,
Suresh
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Kathryn,

We are still working on restructuring the Report. 

We will get back to you with an update hopefully by today.

Thank you.

Regards,
Suresh
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Kathryn,

From our findings, you were unable to capture the value in a variable is due to the Scaffold-data is nested in a Table-data. 

That said, we have tested whereby, we could capture the value of the Scaffold-data if it is not nested in a Table-data. 

Since you're using Report-variable, we wont be able to capture the value as the Scaffold-data is nested in a Table-data. 

As of now, we are still testing the possibility of using Expanded-Reporter to meet your needs. 

We will get back to you in a day or two with our progress. 

Thank you.

Regards,
Suresh
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
I hope this will help simplify the problem.  I don't have to use a report variable.  I just need to be able to provide a table or something to the user to enter the FTE (employee) rates per the fiscal year and then use that table to compute the costs for FTEs per FY.  I have attached a picture i hope will help.
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Kathryn,

Thank you for your clarification.

We will try to restructure the reporting to meet your needs. 

I'll get back to you with my findings. 

Regards,
Suresh
Photo of Kathryn Moye

Kathryn Moye

  • 223 Posts
  • 12 Reply Likes
I found a workaround.  The user can't use a table data, as you have pointed out but he is ok with editing report-variables directly.  So, I put the report-variable definitions with the value set to the appropriate constant for the FTE "rate" on a separate page called "FTE Rates" and did a page include on the report page (so I can use the rates anywhere).  The following code uses those variables set on the other page, FTE Rates.
<code>
<p>
  <ac:structured-macro ac:macro-id="9b17688c-2ac6-4d11-a71c-c82aa6d69eaa" ac:name="include" ac:schema-version="1">
    <ac:parameter ac:name="">
      <ac:link>
        <ri:page ri:content-title="FTE Rates"/>
      </ac:link>
    </ac:parameter>
  </ac:structured-macro>
  <ac:structured-macro ac:macro-id="41ef6894-304b-4b94-b58b-bfde583a81a9" ac:name="htmlcomment" ac:schema-version="1">
    <ac:parameter ac:name="hidden">true</ac:parameter>
    <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
    <ac:rich-text-body>
      <p>Cannot put the table below in a future macro or the formulas won't render to numbers, you get an error.</p>
    </ac:rich-text-body>
  </ac:structured-macro>
</p>
<ac:structured-macro ac:macro-id="2f01cc74-d8b6-43c7-9a16-9bb8df610058" ac:name="report-table" ac:schema-version="1">
  <ac:parameter ac:name="maxResults">5000</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="f4c04265-5499-4dbf-a460-986178eaf087" ac:name="local-reporter" ac:schema-version="1">
      <ac:parameter ac:name="source">TLO List</ac:parameter>
      <ac:parameter ac:name="">page:children</ac:parameter>
      <ac:rich-text-body>
        <p> <ac:structured-macro ac:macro-id="cbd25dbd-1411-415a-9596-d36dccae16a7" ac:name="text-filter" ac:schema-version="1">
            <ac:parameter ac:name="value">FY17-32</ac:parameter>
            <ac:parameter ac:name="">page:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="3ff3e857-46dc-4c6c-b3b2-6b9f5e37856c" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">TLO #</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="22a94922-6e91-44f3-8200-34665f873bde" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">page:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="7f20e369-04a8-401f-8b1d-29cfae9933d5" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">FY17</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="3d074c85-d037-4ca9-8d11-22fd7a3004c1" ac:name="report-block" ac:schema-version="1">
            <ac:parameter ac:name="maxResults">1</ac:parameter>
            <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
            <ac:rich-text-body>
              <ac:structured-macro ac:macro-id="d0ebc480-7744-4d55-944e-6e4b6ece9816" ac:name="expanding-reporter" ac:schema-version="1">
                <ac:parameter ac:name="as">CostTracking</ac:parameter>
                <ac:parameter ac:name="">data:CostTracking</ac:parameter>
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="7477b900-0a42-4035-935f-9e72be16170b" ac:name="local-reporter" ac:schema-version="1">
                    <ac:parameter ac:name="source">@self</ac:parameter>
                    <ac:parameter ac:name="">page:children</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="a02d612b-4ab2-47d3-8f9e-c378c6556b60" ac:name="date-sort" ac:schema-version="1">
                          <ac:parameter ac:name="order">descending</ac:parameter>
                          <ac:parameter ac:name="">page:creation date</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <p>
                    <ac:structured-macro ac:macro-id="adbc2bbc-5a32-45f3-850c-23f59e289882" ac:name="text-filter" ac:schema-version="1">
                      <ac:parameter ac:name="include">.*FY17.*</ac:parameter>
                      <ac:parameter ac:name="">data:FY&gt;first</ac:parameter>
                    </ac:structured-macro>
                  </p>
                </ac:rich-text-body>
              </ac:structured-macro>
              <ac:structured-macro ac:macro-id="ace4a97f-7735-40b8-a557-d6597486e035" ac:name="report-body" ac:schema-version="1">
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="fecaf4a6-f21b-477b-aa7c-fd075878ad53" 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">INLINE</ac:parameter>
                    <ac:plain-text-body><![CDATA[%CostTracking>data:CostperFY% * %variable:FY17Rate%]]></ac:plain-text-body>
                  </ac:structured-macro>
                </ac:rich-text-body>
              </ac:structured-macro>
            </ac:rich-text-body>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
</code>
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Kathryn, 

We are still in midst of investigation, please allow us more time to look into your request.

Thank you.

Regards,
Suresh