Working Group Attendance

In prior versions of Confluence (e.g., v3.5), it was possible within Scaffolding to use a calculated field from one table in another. In particular, I used this feature in the Working Group Attendance template to automate a calculation in the main table, viz:

• Grab Total Meeting Count (TCOUNT) from Table 1; then in Table 2
• If a person Resigned (SKIP > 0, then the Number of Meeting Opportunities = the number in the SKIP field; however
• If a person has not Resigned (SKIP = 0), then the Number of Meeting Opportunities = TCOUNT - JOINED (the week that the person started with the WG).

This capability was enabled by a macro called (Report-On:Injected=TRUE) which stopped working with Confluence upgrade v4.0; then use of a calculation like this: %Data:TCOUNT%-${SKIP}

ServiceRocket has advised me that it is now possible to restore that functionality, so this page will contain my testing results to see if I can make it work.

Hello Ken,

Thank you for contacting ServiceRocket.

Are you using that total for calculation or display only? For
display you may use report-info e.g. {report-info:data:myTable>size}; while
for calculation you may use {eval-data} inside {report-on} e.g.

{report-on:injected=true}
{eval-data:evalTest}
%:myTable>size% - 2
{eval-data}
{report-on}

Hope this helps.

Thanks&Regards,

Ziana