Forum Discussion

Qrew Member

5 years ago

Please Help with Percentage Calculation for a Report Formula

Hey community! Hoping someone can help me craft what must be a simple custom formula in a summary report that I just can't figure out. In my screenshot, I have a simple summary, and what I'm tryin...

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

Try making a formula on each record which calculates to either 0% or 100%. Then put that field on the summary report and select "Average".

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

BobbyHollis
Qrew Member
5 years ago
Hey Mark,

Apologies sir but I'm not following your answer, can you please elaborate a little?

------------------------------
Bobby Hollis
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  The issue is that it is very difficult to do what you are asking. So I'm trying to find a solution.
  
  I'm suggesting that you make a formula which calculates to either 0 or 1 based on a condition being true. Suppose that formula was
  
  IF([Cashflow]="confirmed",1,0)
  
  If you then include that field on the summary report as an Average, and include in the filter where the Cashflow was
  
  any of
  [Cashflow] is confirmed
  [Cashflow] is (leave blank)
  [Cashflow] is maybe
  [Cashflow] is declined
  [Cashflow] is pending
  
  Then the Average of all those 0% and 100%'s will average out the correct result.
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------