Forum Discussion
Average Between two columns
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.
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"))
1 Reply
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"))