/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
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 , Obsolete: BusinessObjects 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
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)