Referencing aggregation in the footer

[ray985]

I have a datapage with several columns of data as well as 3 columns of calculated fields. Currently, these fields are then summed in 3 different aggregation rows at the bottom of my table. Having 3 separate rows is not ideal visually. Also, if possible, I would like to ability to use them in HTML (ie, say "You saved $xx this year). Is there any way to do this? I can't find a way to refer to the aggregate values in the footer or to have it sum the calculated values in the footer itself. (ie SUM([@Savings#]).

[MayMusic]

Can you elaborate what is the calculation and table setting. To have all aggregations show up in one row, you can create a details page and add calculated field with SQL to get the SUM value.

[directrix]

Hello @ray985,

I have this same issue and reached their Support. Since we can't pull the Aggregate Function and enter it in the footer, what they suggest is to create another calculated field to get the aggregated/SUM value of a column. And yes, the above statement is correct, that we can use SQL. And by then, you can use [@calcfield:X] in the footer, since it is available from the picker.

— DTX —