SAP Knowledge Base Article - Public

1366226 - SUMPRODUCT function with condition not supported in Xcelsius 2008

Symptom

  • Cannot use SUMPRODUCT () with condition in xcelsius.
  • Support array as arguments but not as return value in function.

Reproducing the Issue

  1. In excel, create a SUMPRODUCT () with condition as SUMPRODUCT (($A$5:$A$23=A2)*($B$5:$B$23>20)*($C$5:$C$23=C2).
  2. Import this excel file in xcelsius
  3. Map the cell contatining formula to label component in xcelsius.
  4. Preview the dashboard, data is not displayed.
  • Crystal Xcelsius 2008 Service Pack 2

Cause

This functionality is not available in the product.

Resolution

  • An Enhancement Request is raised for this : ER # ADAPT01273256
  • The Enhancement Request (ER) will be reviewed in terms of future product development when considering possible new features in next major release.

Keywords

CX2008, Sumproduct() , KBA , BI-RA-XL , Dashboards and Presentation Design , Product Enhancement

Product

SAP BusinessObjects Xcelsius Enterprise 2008