SAP Knowledge Base Article - Public

1825063 - DSUM function in the Xcelsius returns incorrect value


DSUM function in the Xcelsius returns incorrect value


  • Xcelsius 2008
  • SAP BusinessObjects Dashboards 4.0

Reproducing the Issue

  1. Prepare the data cells in the spread sheet.


  1. Prepare the criteria of DSUM function in the spread sheet.


  1. Type DSUM function in the cell($J$1).

e.g. =DSUM($A:$I, $G$1, $A$2:$G$4)

  1. Type the following function to check the result of DSUM function in the cell($K$1).

e.g. =IF($J$1="","",IF($J$1>0,"Correct","In Correct"))

  1. Insert Label Text component into the canvas and set the cell($K$1) as Link to Cell.
  2. Click Preview.
  3. The Label Text shows "In Correct".



When the row number of Excel is bigger than the value of Maximum Number Of Rows, the excess rows will be abandoned at run-time.


  1. Launch Xcelsius.
  2. Click File > Preferences.
  3. Click Excel Options.
  4. Set the value bigger than the row number of Excel in the Maximum Number Of Rows(Default value is 512).
  5. Close Xcelsius.



ADAPT01683456, TE5000477937, cell, xls, column, excel, xlf, data range , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem


SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008