I am trying to calculate the 4 numerical data fields using eval data and it isn't working?

  • 1
  • Question
  • Updated 1 year ago

I have what I think is a simple question. I am using table data.  I have 4 columns for users to populate numbers using the number data macro. In the reporting table I want to total the 4 columns using the eval-data macro. I am getting an error message in the eval data macro field. Lately, no one has been responding to question, this seems pretty simple,  I would appreciate some assistance.

I am using table data, and the table name is :fit, the 4 number data fields are named: week1, week2, week3, week4


Within the Eval-data macro I have

    
      {week1}+{week2}+{week3}+{week4}
    
This is the error message that I am getting 
Error rendering macro 'eval-data' : The specified expression 
could not be evaluated.


 Below is my markup for the report table.


      <p> </p>
      <p> </p>
      <p> </p>
      <ac:structured-macro ac:macro-id="8f239d0f-1f56-4dd0-8086-9fd737c3a7c1" ac:name="deck" ac:schema-version="1">
        <ac:parameter ac:name="id">gsis</ac:parameter>
        <ac:rich-text-body>
          <ac:structured-macro ac:macro-id="b54086bc-202f-43e0-9b4d-5c8a82d9c75b" ac:name="card" ac:schema-version="1">
            <ac:parameter ac:name="label">Round 1</ac:parameter>
            <ac:rich-text-body>
              <ac:structured-macro ac:macro-id="f680e3f0-9a80-435d-99a5-7683ec70c52b" ac:name="report-table" ac:schema-version="1">
                <ac:rich-text-body>
                  <ac:structured-macro ac:macro-id="60f5c280-590e-4a65-9681-13fea6b68754" ac:name="local-reporter" ac:schema-version="1">
                    <ac:parameter ac:name="source">NS:GSIS-FIT</ac:parameter>
                    <ac:parameter ac:name="">data:fit</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="b8f1b78e-83e2-4623-a9ef-c871a7dc4abd" ac:name="text-filter" ac:schema-version="1">
                          <ac:parameter ac:name="include">.*One.*</ac:parameter>
                          <ac:parameter ac:name="">data:round</ac:parameter>
                        </ac:structured-macro>
                      </p>
                      <p>
                        <ac:structured-macro ac:macro-id="03eb4b16-0510-4896-bf8f-e1121b95416f" ac:name="text-sort" ac:schema-version="1">
                          <ac:parameter ac:name="order">descending</ac:parameter>
                          <ac:parameter ac:name="">data:team</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="d29c6d3e-04f2-44f6-876a-fac2f1b3fde3" ac:name="report-column" ac:schema-version="1">
                    <ac:parameter ac:name="title">Team</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="ff5d98e9-7195-47a4-8223-609075887fbd" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="render">wiki</ac:parameter>
                          <ac:parameter ac:name="">data:team</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="58680f13-b634-4763-bc1e-9180fe3c3eac" ac:name="report-column" ac:schema-version="1">
                    <ac:parameter ac:name="title">Players</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="29569fc8-f7fa-4734-a26b-3d6c405ae4bb" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="render">richtext</ac:parameter>
                          <ac:parameter ac:name="">data:name</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="bd043dc7-21e1-4bab-aa90-858c431817b8" ac:name="report-column" ac:schema-version="1">
                    <ac:parameter ac:name="title">ATTUID</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="2072f9d7-97d9-4612-a3ba-798b99d0077c" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="render">richtext</ac:parameter>
                          <ac:parameter ac:name="">data:UID</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="29335233-5835-49b3-85e1-1dee6807b234" ac:name="report-column" ac:schema-version="1">
                    <ac:parameter ac:name="title">Country</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="31c216c1-c793-4de5-bb10-5f44d7694777" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="render">wiki</ac:parameter>
                          <ac:parameter ac:name="">data:country</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="817e2fe1-0f98-4339-a6c1-e35566a644b4" ac:name="report-column" ac:schema-version="1">
                    <ac:parameter ac:name="title">Week 1</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="338e89d0-ab07-4411-94be-e7b045f8eebf" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="render">wiki</ac:parameter>
                          <ac:parameter ac:name="">data:week1</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="1a7c6b54-58fd-4002-8d81-7baa1600f146" ac:name="report-column" ac:schema-version="1">
                    <ac:parameter ac:name="title">Week 2</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="2cfcb76b-872b-4a9e-ac27-c99e286c88a2" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="render">wiki</ac:parameter>
                          <ac:parameter ac:name="">data:week2</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="035e8850-1284-4853-9891-26c1965e9bee" ac:name="report-column" ac:schema-version="1">
                    <ac:parameter ac:name="title">Week 3</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="4a97729c-68fd-4721-aa5b-6d337c69f009" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="render">wiki</ac:parameter>
                          <ac:parameter ac:name="">data:week3</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="11da8ba1-a7a3-474c-bb94-c9b560cb2cd8" ac:name="report-column" ac:schema-version="1">
                    <ac:parameter ac:name="title">Week 4</ac:parameter>
                    <ac:rich-text-body>
                      <p>
                        <ac:structured-macro ac:macro-id="c8f7a633-7861-465a-923f-2ac3c5946430" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="render">wiki</ac:parameter>
                          <ac:parameter ac:name="">data:week4</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </ac:rich-text-body>
                  </ac:structured-macro>
                  <ac:structured-macro ac:macro-id="31da8943-8463-4e7c-90b8-63e538888a2d" ac:name="report-column" ac:schema-version="1">
                    <ac:parameter ac:name="title">Total</ac:parameter>
                    <ac:rich-text-body>
                      <ac:structured-macro ac:macro-id="a0f26b19-29de-468a-8855-a2b20417a6fa" ac:name="eval-data" ac:schema-version="1">
                        <ac:parameter ac:name="format">##,###</ac:parameter>
                        <ac:parameter ac:name="name">total</ac:parameter>
                        <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
                        <ac:plain-text-body><![CDATA[{week1}+{week2}+{week3}+{week4}]]></ac:plain-text-body>
                      </ac:structured-macro>
                      <p> </p>
                      <p> </p>
                      <p> </p>
                    </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>
    </ac:rich-text-body>
  </ac:structured-macro> </p>
<p> </p>


Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like

Posted 1 year ago

  • 1
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Martrice,

Can you please share the following with us :

Meanwhile can you please elaborate on the followings: 
  • Version of Confluence
  • Version of the plugin
Thank you.

Regards,
Suresh
Photo of Martrice Denson

Martrice Denson

  • 112 Posts
  • 1 Reply Like
confluence 5.8.18, reporting 6.3.1, scaffolding 8.2.2
Photo of Suresh Mathusuthanan

Suresh Mathusuthanan, Alum

  • 117 Posts
  • 9 Reply Likes
Hi Martrice, 

Thank you for the information. 

The storage format you shared with us seems truncated.

I believe we have a ticket with you in regards of this issue. Can you please reach out to us there and share the storage format in a.txt file. 

Regards,
Suresh
Photo of Dan

Dan

  • 9 Posts
  • 0 Reply Likes
I'm receiving the same error for a simple expression. e.g. {numberA} - {numberB} = Error rendering macro 'eval-data' : The specified expression could not be evaluated.

Has a solution been posted for this that's outside of the support ticket mentioned above?