SAP Knowledge Base Article - Preview

1203748 - How to calculate the average, including all the null values.


How do you calculate an average, including null values in Desktop Intelligence?

For example, you have a report showing revenue for each month. However, May is the only month that has any revenue ($5,345.00). If you put an average calculation on the column, it will show an average of $5,345.00 because the other cells are empty, not zero. This would not be an accurate average. You want to get an average, including all the months with no revenue as well.



SAP BusinessObjects Business Intelligence platform 6.5 ; SAP BusinessObjects Business Intelligence platform 6.5.3 ; SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI ; SAP BusinessObjects Enterprise XI 3.0


avg zeroes , 7066642 , KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.