Average Between two columns

[Jmccoy]

I have a fairly simple problem that I need help with. Just can't seem to wrap my mind around the correct way to go about it. 

I have a total sales column that provided a total for all projects entered into our system. These projects can be defined by the following status: Q for Quote and PJ for promise job. This is in a separte column within the same table. 

I am wanting to provide the difference between the count of projects quoted compared to the count of the projects made into a promise job. Providing a sort of hit ratio. 

[amitchandak · Accepted solution]

@Jmccoy , hope I got it right

calculate(count(table[project]), Table[status1] = "Q") - calculate(count(table[project]), Table[status2] = "PJ")

Or

divide(calculate(count(table[project]), Table[status1] = "Q"),calculate(count(table[project]), Table[status2] = "PJ"))