mathematical functions that exclude zeros and NULLs

[Lynn]

We would like the ability to have math functions (like Avg) that exclude 0 and nulls.

[Edward]

Hi Lynn,

Please use the following expressions:

// with 0 values included, without nulls:

Code: Select all

{Div(Totals.Sum(MyDataSource, MyDataSource.MyDataColumn),Totals.Sum(MyDataSource,IsNull(MyDataSource,"MyDataColumn")?0:1),0)}

// without 0 and nulls:

Code: Select all

{Div(Totals.Sum(MyDataSource, MyDataSource.MyDataColumn),Totals.Sum(MyDataSource,(MyDataSource.MyDataColumn==0)|IsNull(MyDataSource,"MyDataColumn")?0:1),0)}

Thank you.