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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get Summary sorting problem - with using If

Status
Not open for further replies.

esomers

Technical User
Jun 11, 2009
2
US
Let me ask this question in a different manner.

I have a field in a table called Element type. In this field i have about 100 choices in my drop down menu that is selected for every record (along with other multiple criteria). That field is entered through a portal -- so every
entry creates a related record. In that related record i assign a value in a field called Cost Percentage.

My goal is to be able to create a report that assigns a multiplyer that is specific to each Element type and get a total cost for all same elements in the database.

I thought the best way to go about this was to create new get summary fields that appear on another layout. Here is an example of one of them

GetSummary(Cost Percentage Total; If( Element Type = "Sky Environment"; Cost Percentage Total)) * (9000). This is one of about one hundred so I am looking for an automated way to get all these values in one layout that I can print out as a report.

RIght now i have tried putting all these into sub summary parts and body parts. As well adding an additional sub summary part that just shows
element type and cost percentage total. None work when sorted by element. The only way I get a returned value in the calculation field example above -- is for me to manually go into the related Layout with all elements as individual records and do a manual sort. Then on what I had hoped to be an overall report layout only that one field that represents the sort criteria that I sorted by shows up with a returned value. How can I get all the fields to return their value when I sort by element Type.

SOS I have spent a whole day without results and am on a deadline.

Esomers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top