Jump to content
Sign in to follow this  
hassam36

summing field values in a portal

Recommended Posts

Hi

I have a portal on a layout that has a dollar amount field and a "cost center" field in it among others.

I would like to include another field that sums the dollar amount field for all records that have the same cost center value.

I did this previously using a portal sort equal to the cost center field, a summary field for each record, and used a GetSummary() function that had a breakField equal to the cost center field. However, this no longer functions because I had to change the portal to reflect a second instance of the underlying table.

Does anyone know of another way to achieve this?

John

Share this post


Link to post
Share on other sites

Yes, create a sub-summary report by Cost Center in the table upon which the portal is based.

Share this post


Link to post
Share on other sites

How will creating a sub-summary report allow me to populate a summary field in the portal on my layout though?

John

Share this post


Link to post
Share on other sites

It doesn't. You asked for another way to achieve "this" and by "this" I thought you meant amounts by cost center.

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
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.