1203839 - Why is it that formulas similar to "=SUMIF(Sect1!$C:$C,B27,Sect1!$I:$I)" never work in Xcelsius?

SAP Knowledge Base Article - Public

1203839 - Why is it that formulas similar to "=SUMIF(Sect1!$C:$C,B27,Sect1!$I:$I)" never work in Xcelsius?

Symptom

Why do formulas similar to:

"=SUMIF(Sect1!$C:$C,B27,Sect1!$I:$I)"

not work in Xcelsius?

Resolution

Looking at the formula, notice that the range selection (Sect1!C:$C) is the entire column. In any Excel function where there is a range selection, the range must be specified.

For example:

$C$4:$C$22

Keywords

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

Product

SAP BusinessObjects Dashboards 3.0 ; SAP BusinessObjects Dashboards 3.5 ; SAP BusinessObjects Dashboards 4.5 ; SAP BusinessObjects Dashboards software 4.0