tackermax

How to get a total from multiple summary fields?

Discussion created by tackermax on Mar 25, 2016
Latest reply on Mar 25, 2016 by keywords

This is a really simple one...

I have multiple summary totals from many different related tables.  However, if I try to do a sum() calculation of all the fields, nothing shows up.

I found GetSummary(), but that all has to be on the same table, I believe.  It's just a straight up addition of summary fields from many tables.

 

Sum ( Bank_accounts::accts_total;

Business_Interests::total_business_value;

Income::total_income_partners;

insurance::final_benefit_total;

Money_owed::total_owed;

Money_owed::anticipated_total_value;

Money_owed::other_assets_total_value;

personal_property::total_market_value;

properties::total_equity;

retirement_plans::ret_plan_total_value;

stocks::stock_bonds_investments_total_amount; )

Outcomes