AnsweredAssumed Answered

Summing of multiple filtered portals

Question asked by AaronTang on Dec 21, 2011
Latest reply on Dec 21, 2011 by philmodjunk


Summing of multiple filtered portals


 Hi, I've got 3 tables - commissions, products and services. In the commissions layout, there are two portals - one for product sales and one for services rendered which are retrieved from other relationships in the database. As I require filtering of the portals, I made a summary of the product totals and service totals within each portal. Thus, I was able to sum the individual filtered portal but faced difficulty in summing the resulting sums of the two filtered portals to generate a final amount. Any suggestions?