Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Base field not showing up in the Summary

Status
Not open for further replies.

adubrovs

Technical User
Joined
Feb 24, 2011
Messages
23
Location
CA
I created the following formula field that I would like to then sum based on a specific grouping, however, it's not showing up as a field to summarize on.

{PF_SECS.MARKET_VALUE} / Sum ({PF_SECS.MARKET_VALUE}, {PORTFOLIOS.PORTFOLIO})

Any help would be appreciated.
 
You can use variables to sum this. Create three formulas (assuming you want to reset the result per some group):

//{@reset} to be placed in the group header (portfolio group?) corresponding to the group footer where you want the result and suppressed:
whileprintingrecords;
numbervar x;
if not inrepeatedgroupheader then
x := 0;

//{@accum} to be placed in the section containing the formula you want to sum (suppress this):
whileprintingrecords;
numbervar x := x + {PF_SECS.MARKET_VALUE} / Sum ({PF_SECS.MARKET_VALUE}, {PORTFOLIOS.PORTFOLIO});

//{@display} to be placed in the group footer:
whileprintingrecords;
numbervar x;

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top