Are the figures 17,909,386 and 34,752,939 themselves summary data (in other words, is each line of your report a sub-summary)? If so, you will need to use the GetSummary () function in order to perform calculations with it.
On the other hand, if each line is a single record it is a simple matter of calculating the appropriate percentage from the data fields. You might even be able to do this anyway, and then average the individual percentages as your summary field, but I'd need to test that to see if it produces the right result.
Good morning! Yes, each quantity you see in this report is a summary. Would you mind explaining more about how I can use the GetSummary() function to make this work? Do I create a field in the table? I've tried your suggestion a few ways and while I feel it puts me on the right track I'm still floundering on using it properly.
1 of 1 people found this helpful
Thank you again for the assist. Unless there's a more simple way, here's what I did based on your comments. I created a field that is the following calcuation:
GetSummary( Summary of Payment ; Service Category ) / GetSummary( Summary of Charges ; Service Category ).
Adding that field to the individual categories gave me the correct percentages. Additionally I had to create fields that captured the summary based on the other summaries I have in the report. So I have these additional field I added:
GetSummary( Summary of Payment ; Product ) / GetSummary( Summary of Charges ; Product )
GetSummary( Summary of Payment ; Patient Type ) / GetSummary( Summary of Charges ; Patient Type )
GetSummary( Summary of Payment ; Hospital ) / GetSummary( Summary of Charges ; Hospital )
Adding these new fields to the appropriate section of the report gave me the correct calculations. If there's a way to only have one field to do all the heavy lifting instead of four I'd be all ears.
Thank you keywords for putting me on the right track.