I have what seems a simple issue about making an average number but can’t seem to solve it. I have an app that collects test results and I have 20 numerical fields that will get these test results. Sometimes there can be 1 test sometimes there can be 5, 20 etc… I have tried using the average expression how ever it adds all the values then divides it by 20 automatically so if I only have 5 tests it will still get divided by 20.
I tried COUNT() to count the numeric fields but it gives me an answer of 20 even if all the fields are “empty/not used”. I think this is because the default of number is 0?
Is there a simple way of solving this?