• 0
Login to follow this  
ray985

Referencing aggregation in the footer

Question

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#]).

Share this post


Link to post
Share on other sites

1 answer to this question

  • 0

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Login to follow this