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

  • 0
  • 1
  • Question
  • Updated 8 months 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

  • 100 Points 100 badge 2x thumb

Posted 8 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
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,438 Points 20k badge 2x thumb
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.
Photo of thomas Cates

thomas Cates

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