Re: Please Help with Percentage Calculation for a Report Formula

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
------------------------------