Expand all | Collapse all

Formula help

  • 1.  Formula help

    Posted 06-07-2017 21:21
    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.">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1607376/RackMultipart20170607-71761-cmu5ra-Capture_Specialty_inline.PNG?1496870374">

  • 2.  RE: Formula help

    Posted 06-07-2017 21:28
    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.

  • 3.  RE: Formula help

    Posted 06-07-2017 21:41
    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

  • 4.  RE: Formula help

    Posted 06-07-2017 23:24
    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.

  • 5.  RE: Formula help

    Posted 06-07-2017 23:42
    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.