Passing an aggregate value on to another datapage

[JMR21]

I have an aggregate value calculated (sum of purchases) on a report for a given customer.  I would like to use that value in a separate pymt summary datapage that would show the total purchases.  Is it possible to pass that parameter on if it is not a field in the table?

[TellMeWhy]

Hi @JMR21,

If your payment summary DataPage is Details DataPage, you can try using Calculated Value field instead and create a formula there that will take the sum of purchases of that given customer.

 

Here are some articles that may help you with this problem

https://howto.caspio.com/datapages/datapage-components/calculated-values/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

 

[JMR21]

@TellMeWhyThank you.  Those were great articles.  It didn't solve my problem but it gave me some new ideas!  Thanks again for the reply!

 

[SinJunYoung]

On 11/5/2020 at 8:04 PM, JMR21 said:

@TellMeWhyThank you.  Those were great articles.  It didn't solve my problem but it gave me some new ideas!  Thanks again for the reply!

 

You can also make use of Pivots on these: https://howto.caspio.com/datapages/reports/pivot-table/