1546411 - Error "Unsupported Excel function: QUARTILE" comes while using Quartile function in Xcelsius 2008

SAP Knowledge Base Article - Public

1546411 - Error "Unsupported Excel function: QUARTILE" comes while using Quartile function in Xcelsius 2008

Symptom

  • Error "Unsupported Excel function: QUARTILE" comes while using Quartile function in Xcelsius 2008
  • Quartile function has been mentioned as supported function in Xcelsius.

Environment

Xcelsius Enterprise 2008 Service Pack 3 Fix Pack 3.3

Reproducing the Issue

1. Launch Xcelsius.
2. Enter numeric values in column A (say A1:A10) in Excel spreadsheet.
3. Write below formula in B1:
         =QUARTILE(A1:A10,1)
4. Insert a Spreadsheet component on canvas and map it with B1.
5. Click on Preview."Unsupported Excel function" error will come up.

Cause

This issue has been addressed as a documentation bug under ADAPT01510488.

Resolution

The fix for this bug has been targetted for XI 3.1 Service Pack 4.

Workaround:

Follow the below steps in order to calculate first Quartile in Excel:

Replace

=QUARTILE(A1:A10,1)

By

=INDEX(A1:A10,ROUNDUP((COUNTIF(A1:A10,"<>0")*0.25),0))

Note:

We can use 0.5 for 2nd Quartile and 0.75 for 3rd Quartile in place of 0.25 in the above formula.

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008