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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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.
Photo of thomas Cates

thomas Cates

  • 120 Points 100 badge 2x thumb

Posted 1 year ago

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

Matthew Neil

  • 31,698 Points 20k badge 2x thumb

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.
Photo of thomas Cates

thomas Cates

  • 120 Points 100 badge 2x thumb
Thank you, both! These helped tremendously.