Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Running Calculations Based on a Portal Column


Recommended Posts

Hey guys, it seems like there must be a simple answer to this question:


I have 2 tables– Table A has records of advertisers (including fields with numbers of ad views we promised them for the length of the ad campaign), and Table B that displays records from the first table via a portal. I've rigged this table with a month and year popup menu so that the portal only shows advertisers that fall under the currently selected month and year. Works awesomely. Problem is I need to do a calculation and then a SUM to that "Number of Ad Views" column for all the advertisers that are currently being shown in the portal... and the calculation I have to do to each of those fields is directly related to the month that was chosen in the popup menu, and some other info that's on Table A. In fewer words, I'd like to be able to have a calculation field sitting in Table B that does a calculation to each field in the portal column and then sum the results. I don't think I can simply have the calculation field in Table A, because it bases some of the calculation on what month and year is chosen in the popup menu in Table B. What is there to do?

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use