Hello !
Sorry I'm a french speaking newbie.
I'm using :
I have a 43 rows tab, but only 38 with datas in fifth column (see attached screenshot).
I checked calculation and noticed rows with no data are not ignored for fifth column calculation...
I want average to be calculated only with 38 rows, not with all rows, same for count...
I also tried to check COUNT(%s) in custom tab option for 5th column element : result is 43 rows
This problem occurs in all rows with no data (average, count are calculated on 43 rows).
And Sum is not the same when I check sum in .xls tab, in that column (and some others too)...
I missed something for sure...
Thanks for your help...
Sorry I'm a french speaking newbie.
I'm using :
- 3.9.2 Fabrik
- 3.9.14 Joomla
- 10.3.24-MariaDB server
- Firefox 89.0.2
- unfortunately, not allowed to update server settings (nor joomla version)
I have a 43 rows tab, but only 38 with datas in fifth column (see attached screenshot).
I checked calculation and noticed rows with no data are not ignored for fifth column calculation...
I want average to be calculated only with 38 rows, not with all rows, same for count...
I also tried to check COUNT(%s) in custom tab option for 5th column element : result is 43 rows
This problem occurs in all rows with no data (average, count are calculated on 43 rows).
And Sum is not the same when I check sum in .xls tab, in that column (and some others too)...
I missed something for sure...
Thanks for your help...