I have a formula field that calculates a percentage from two fields. It does the job but it's messed up on a table report. For example, i have a customer that has 4 projects and one project is 14% done, second is 0%, third is 89% and the forth is 27% done. The totals in the table report then shows 131% and it should be 57%. The grand total calculates all of the percentages that go over 200% and still rising, while i would like to know only within 100%.
Is there a way to make the total calculate correctly? The report is grouped and sorted by the customer.