/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
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.
Read more...
Product
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
Keywords
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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)