Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 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 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.
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 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.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    7 years ago
    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.