Showing percentage on summary report
I have two fields, one shows is "?1261.01" and the other is a total field "?4651.19". I want to show this as a percentage on a summary report. So I did a calculated field which did ?1261.01 / ?4651....
Forum Discussion
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.