Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 3 columns User Id, Name , Test Score with values ,but there are null values for Test score alone,
I need to write an expression to find the count of User Id's with Test Score to find out the percentage of Users who have completed the tests
Attached is the data sheet.
Tried with the below expression but it failed..
count(if not isnull(testscore), testscore))
try like:
=count(if (len(trim([Test Score]))>0, [Test Score]))