Formula help

  • 0
  • 1
  • 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.
Photo of QuickbaseUser

QuickbaseUser

  • 474 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
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.
Photo of QuickbaseUser

QuickbaseUser

  • 474 Points 250 badge 2x thumb
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
Photo of QuickbaseUser

QuickbaseUser

  • 474 Points 250 badge 2x thumb
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.


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
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.