SAP Knowledge Base Article - Preview

1515645 - Error in SUMIF formula

Symptom

  • Xcelsius dashboard show the incorrect figures when SUMIF and CONCATENATE functions are use in the same function call. If the first three characters of the output show any sign of representing a month (format MMM), the fomula will fail to show up correctly.
       E.g "Mary" where first 3 characters are "Mar" which can represent March
            "Julia" where first 3 characters are "Jul" which can represent Jul


Read more...

Environment

  • Adobe Flash Player 10
  • Microsoft Excel 2007
  • Xcelsius 2008 with Service Pack 3 (ver 5.3.0.0 Build 12,3,0,670)

Product

SAP BusinessObjects Business Intelligence Edge 3.1, standard package

Keywords

BOJ , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , 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.