How to get the average excluding zeros
Hi,
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.
1 answer
Hello, Walter,
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.
Regards,
WebDataRocks Team