I have a column that is the number of visits someone made to a location. I need to create another column in zoho reports that shows what percent each visit is of the total visits. I tried to use the formula (sum(visit)/visit) as a percent but I get an error saying cannot mix aggregate and none aggregate functions. When looking up the issue I got the formula above from a solution somone had given on how to do it and they said it worked but it isn't working now because of the error. What is the best way to do this?