We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

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.

1 answer

WebDataRocks Team WebDataRocks December 9, 2020

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.

WebDataRocks Team