Hello!
I have a form all set up for a weekly reading game. To speed things up for the person running the game I wanted to use the rating field to record how many minutes they read on their reading log. (One tap vs two taps into a picklist).
I am having troubles setting up a calculation however for the sum total of spaces filled. I did [Week 1]+[Week 2]+… etc. but it reports as decimals and all sorts of crazy numbers.
Can I not sum up ratings or do I need to do some more setup?
Thanks!
Hi Laura,
You can certainly sum up your rating fields.
There are a couple of ways to do it. One is with the formula you’ve provided. However, if the rating field had no value in it, it would be empty, so you’ll need to surround your [Week 1] fields with an IFEMPTY() function check. For example:
IFEMPTY([Week 1]; 0; [Week 1]) + IFEMPTY([Week 2]; 0; [Week 2]) + ... + IFEMPTY([Week N]; 0; [Week N])
So from Week 1 to Week N. What that will do is return 0 if a Rating value had never been set before or the actual value if it had been set before. There’s a difference between an empty value and a 0 value in Tap Forms.
The other way is to use the Total function on the records list screen to view the total at the bottom. You can set the “Summary Calculation” option to Total on the Field Options screen for your Rating field. Then when you look at the records list, you’ll see the total of that Rating field across all records.
Hope that helps!
Brendan
The IFEMPTY() function did the trick. Thank you so much.
I am honestly impressed with your forum responsiveness – it’s so awesome.
.
