How to get the average excluding zeros

posted on November 26th, 2020

Resolved

Walter asked November 26, 2020

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

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.

Regards,
WebDataRocks Team