Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

How to calculate strike rate (Win or Lose) for bids

Hi. New to QuickBase but couldn't find the answer to this. I have a table that lists bids that have been received. We have events called BDM Camp and I need to find a way to calculate when a BDM Camp...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Because you want to calculate three outcomes, I suggest making three formula % formula fields.

The formula for [Awarded %] would be

IF([Job Outcome] = "Awarded",1,0)

and then similar for the others.

Then the magic is that if you make a summary report all those 100% and 0% will average out.