Pass column total values to html page and/or virtual field

[AdamS]

I am trying to pass the value from specific column totals for use in html page(s) and/or virtual fields. Any help is appreciated.

e.g. table with 3 columns and n rows

I want to retrieve and pass the total value of column 1, column 2 and column 3 for use on a different webpage or for a custom html field

Thanks in advance

[Vitalikssssss]

Hi AdamS,

I am afraid that you cannot pass Total & Aggregation field value.

I would recommend using calculated field with SQL expression in order to display table sum value in Datapage which has a different datasource table.

Here is an example of SQL expression:

SELECT SUM(Sales) FROM Sales_By_Region_TBL WHERE SaleRep_ID = target.[@field:SaleRep_ID] 

Hope this helps.

Regards,

vitalikssssss