Skip to main content
Question

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

  • March 19, 2018
  • 0 replies
  • 100 views
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 is held, the ratio or percent of the bids that are Awarded, Lost or Cancelled. (I need to divide the number awarded or lost or cancelled into the total amount of bids that had BDM Camp)

The bids are represented by a specific code for that Bid. The event is called BDM Camp and then results are a field called BDM Award Outcome (answers can be Awarded, Lost, Cancelled). I tried writing formulas, but I keep getting the notification that I am using "/" incorrect or Average incorrect.
Any help is appreciated.
This topic has been closed for replies.

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.
  • MCFNeil
  • Registered
  • March 22, 2018
Thomas,  

It looks like you have 2 tables, Camps and Bids.
Each Camp has many Bids, correct?
Any you track the 'status' of the bid on those records, correct?

(If so, and I hope this is your set up)

You will want to summarize 4 values from the [Bids] table up to the [Camp] table.
# of Bids (this is a total, regardless of result/status)
# of Bids Awarded (# where the status = "Awarded")
# of Bids Lost
# of Bids Cancelled

Now for each camp you will have the 4 values needed to do any type of calculations or ratios.

i.e. Won/Lost ratios, or % Won, etc.

This also puts the 'reporting' on the level of the [Camp] table, and you can compare camps better.
  • ArchiveUser
  • Author
  • Registered
  • March 22, 2018
Thank you, both! These helped tremendously.
Terms & ConditionsAccessibility statement