Forum Discussion
Hadill
Helper I
Helper IWin Rate
Hi there! I have a table with the 'Sales Information', includes the follwing columns: [Deal Status] -> Active, Signed, Abondend, Booked, Lost. [Deal value] -> Numeric Data. I want to add a new...
amitchandak
Super User
Super UserHadill , where are these values
won deals value/ won deals value+ lost deals
Can you share sample data and sample output in table format?
HadillHelper I
Helper IHi amitchandak , thanks for replying.
By Won Deals value i mean the sum of the deal values that corresponds Booked status.
And the same for Lost Deals value, corresponds Lost status.
So it should be : win rate= sum of [deal value] for the booked [deal status]/sum of [deal value] for the booked [deal status]+sum of [deal value] for the Lost [deal status].
Example of the columns:
| Deal value | Deal status |
| 500 | Booked |
| 1000 | Abounded |
| 400 | Booked |
| 1500 | Lost |
| 2000 | Lost |
| 1500 | Abounded |
| 4000 | signed |
I hope it is more clear now