mathematical functions that exclude zeros and NULLs
Posted: Wed Oct 21, 2009 10:28 am
We would like the ability to have math functions (like Avg) that exclude 0 and nulls.
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)}Code: Select all
{Div(Totals.Sum(MyDataSource, MyDataSource.MyDataColumn),Totals.Sum(MyDataSource,(MyDataSource.MyDataColumn==0)|IsNull(MyDataSource,"MyDataColumn")?0:1),0)}