calculate average excluding 0 values

[kt708]

Hi,

I use Jasper Analysis Schema Workbench and want to figure out how to calculate average in hierarchy.

for example, if one level has 10 values, 2 of which are 0, I want an average of 8 non-null values for the upper level.

do I need to make a change in xml view?

any help or comment would be appreciated.

Koya