Forum Discussion
AndrewAndrew1
11 years agoQrew Member
Hi Thanks for the response
Basically I have a list of deals done by salesman and the report I am trying to create summarizes the deals as a total per salesman. Then I have inserted some columns to show on the report, one of these is new business, the other existing business, then a total of new and existing, then i need a formula which shows how much new business they have done as a percentage.
So effectively New Business / Total GP this needs to show the percentage of the total per salesman line. I have tried to insert a new field and do it that way and also tried to insert a calculated column directly in the report but with no success.
Basically I have a list of deals done by salesman and the report I am trying to create summarizes the deals as a total per salesman. Then I have inserted some columns to show on the report, one of these is new business, the other existing business, then a total of new and existing, then i need a formula which shows how much new business they have done as a percentage.
So effectively New Business / Total GP this needs to show the percentage of the total per salesman line. I have tried to insert a new field and do it that way and also tried to insert a calculated column directly in the report but with no success.