# Formula help

• 0
• Question
• Updated 2 years ago
• In Progress
I've 2 summary reports, one by SDA and another one by Contracting Status. I want to find the percent for each SDA for each 'Alternate Specialty'. For instance, if the  PCP is 2 for Bexar SDA and total number of records for Bexar SDA is 164, i want to display the percent (2/64 * 100) which is ~3%.
Is it possible to achieve this.
Any help appreciated. Thanks.
• 494 Points

Posted 2 years ago

• 0
• 75,144 Points
You may be in luck.

On your summary report, summarize the same value again, (add a new value to summarize with the green + sign)  but this time select the option for % of column, as opposed to Total.
• 494 Points
Ok, but this is calculating the percent by taking the total for the 1st report , (2/3)*100 = ~66.7%.
I want the calculation based on the totals of the 2nd summary report. Is it possible
• 494 Points
Thanks Mark....i got it....played with it for a while..i was trying to show the totals along with the percent which is not possible in the Summary report.

• 75,144 Points
OK, I am glad that you got it to work.  But I'm not understanding your comment that you cannot summarize more than one value.  You can configure other values summarize, even if it is the same field just summarized a different way.