SAP Knowledge Base Article - Preview

1338873 - Incorrect Results with multiple group functions and a where condition in a Web Intelligence Report.

Symptom

  • Data displays as O(Zero) in a Web Intelligence(WebI) report if it has multiple group functions and a where condition like in the formula stated below:

=Sum(Count([object];Distinct)) Where ([object] <> ("COMP") And [object] <>("TERM"))

  • Incorrect results in variables with SUM ... WHERE ... ForALL functions in a Web Intelligence Report migrated from XI R2 to R3

 


Read more...

Environment

  • Business Objects XI R3 SP3 FP3.5 and FP3.6
  • Windows
  • Unix

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

sum function, ADAPT01556223, ADAPT, 01556223 sum(). count function. count(). where clause. , KBA , BI-RA-WBI , Web Intelligence , Problem

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.