1) No Progress 8 for Y7 - Y9? See https://www.4matrix.com/node/6222
2) KS5 Value Added showing warning triangles? See https://www.4matrix.com/help/ks5_va_2018.pdf
3) Up-to-date information on getting help with 4Matrix: https://www.4matrix.com/help/getting_help.pdf
This is a common problem with Excel. The blank cells in the export are actually set to ‘Null’ instead of blank, which is why they are being included in the COUNTA.
There is another formula that you can use, which we’ve tested, and it seems to be more accurate:
As of February 2017, Results Overview is the only export which 'auto-converts' NULL values to blank.
Article ID: 157
Category: Exporting Data
Date added: 03/01/2017 12:01:54
Views : 276
Rating (Votes): (16)