Category Archives: InfoPath

Calculating Totals and Rounding Percentages In InfoPath

Hey Folks,

This is more of a specific scenario I configured for a SharePoint team site where I have created the SharePoint list using InfoPath 2010.

The requirement was fairly simple; total up 17 numbers and provide and round up their percentage of 100. All my score fields get values from 1 to 5 where 5 is the best score (so a perfect score would be 17*5=85) and 1 is the worst score. I was able to perform the above with the following formula:

round((sum(Score 1) +   sum(Score 2) + sum(Score 3) + sum(Score 4) + sum(Score 5) + sum(Score 6) +   sum(Score 7) + sum(Score 8) + sum(Score 9) + sum(Score 10) + sum(Score 11) +   sum(Score 12) + sum(Score 13) + sum(Score 14) + sum(Score 15) + sum(Score 16)   + sum(Score 17)) * 100 / 85)

Here is the video that walks through the above:
Length: 5:26