Hi Jan, Your second version is what I have replicated. In inputted your formula SUM/COUNT*100 in the formula aggregation but the value is showing as 0.00 I checked to make sure that the basic Count and SUM are working and they are so not sure why its not calculating the two together to give me a percentage of the overall count.
Hi There, I am new to Caspio and was hoping someone could help me. I have compiled a table of results and in my last column I built a calculated field which produces an outcome of either Win or Loss. At the bottom I am trying to create a COUNT formula for aggregation so I can build a percentage which shows the amount of wins as a percentage of the total count. Is there a way to do this? Thanks Warwick