How to get the average excluding zeros
I want to exclude the zeros for the grade point average, I tried with this formula “if( (‘Exam’) > 0, sum(‘Exam’)/count(‘Exam’), )” but it is not working.
Thank you very much for your help in advance.
Thank you for your question.
Currently, it is not possible to leave the value of the calculated measure blank.
As a workaround, we suggest removing a cell’s content using the customizeCell API call.
We hope it works for you.