Hi All,
Any ideas how I can run sum simple maths using the code below?
I need to subtract "report-info:data:Sum" from "report-info:data:startvalue"
Any ideas?
Cheers
|| Starting Value || Difference || New Value | |{report-on:injected=true} {report-block} {local-reporter:page:children|source=PAGETITLE0 Portfolio} {text-filter:page:title|include=.*%data:Client > page:title%.*} {local-reporter} {report-body}{report-info:data:startvalue|format=£###,###.##} {report-body} {report-block} {report-on} | | {report-on:injected=true} {report-block} {local-reporter:page:children|source=PAGETITLE0 Portfolio} {text-filter:page:title|include=.*%data:Client > page:title%.*} {local-reporter} {report-body}{report-info:data:Sum|format=£###,###.##} {report-body} {report-block} {report-on} |
Hello!
For any calculations in Confluence, including any manipulations with table data, you may use CelesteCS Math for Confluence.
Assume you have a table with three columns and three rows on your page – from A1 till C3, where row 1 is the header row. The sum calculation formula for rows 2 and 3 will be simple:
SUM(Table1.A2:C3) |
There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.
Thanks!
I'm a little confused about exactly what you're trying to output here, and why you're not using a {report-table} instead of {report-block}.
To do maths, you use the {report-eval} macro. Something like '{report-eval}%data:startvalue% - %data:Sum%{report-eval}' in your case. But I"m confused by the rest of the report, I'm afraid. I would expect you would just do something like this:
{report-table} {local-reporter:page:children|source=PAGETITLE1 Portfolio} {text-filter:page:title|include=.*%data:Client > page:title%.*} {local-reporter} {report-column:title=Starting Value}{report-info:data:startvalue|format=$###,###.##}{report-column} {report-column:title=Difference}{report-info:data:Sum|format=$###,###.##}{report-column} {report-column:title=New Value}{report-eval}%data:startvalue% - %data:Sum%{report-eval}{report-column} {report-table}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.