BusinessObjects Board

Converting Excel Formula to work in Xcelcius

other Xcelsius - Crystal Dashboard Design
#1

Hi. I am working on an Excel formula for a project. It works fine in Excel but breaks to pieces in Xcelsius. After some research I found out that Row and Arrays in general just do not work. So, I was wondering if anyone knew how to convert the following to something that would work. I have spent a few hours on this myself with no success.

Thanks for any help I could receive.

=IFERROR 
(
   INDEX($J$2:$J$169, SMALL (IF($M$2=$A$2:$A$169,ROW($J$2:$J$169)-1,""),ROW()-3)),""
)

[Moderator Edit: Added code formatting - Andreas]

shawlemmond (BOB member since 2015-02-18)

#2

Hi

IFERROR is not supported. You have to use the excel 2003 syntax of IF(IsError(<…>),0,<…>)

cdavies :uk: (BOB member since 2005-01-28)