I have 7 fields - R1 through R7. I want the calculation to find the average of the numbers that a user enters in each field. The tricky part is that I want to drop the decimal place of the final average, instead of having it rounded.
I have been able to create the Average in the Simple Calculation menu, and setting the decimal places to "0" in the Format menu, however it still rounds the decimal places instead of removing them.
If anyone could provide me any suggestions or ideas on how to start creating a function for finding an average and removing the decimal places it would be greatly appreciated. Thanks!
You this as the custom validation script of the field:
event.value = Math.floor(+event.value);
That worked great, thank you very much! ^_^
I never thought of adding the script in the validation field - definitely saves some work!