BusinessObjects Board

Re: Excel Formula Not Working

other Xcelsius - Crystal Dashboard Design
#1

Hello Experts,

Tool - SAP Dashboard 4.1 SP2

I am using a history component in my dashboard and trying to find the max number of selection from a list box.

I am using below formula:

=IF(OR(ISBLANK(F12),F12=""),"",MAXA(IF($F$3:$F$12=H12,$G$3:$G$12)))

while doing preview, I am not able to see any changes in these cells, they are always displaying 0 based on the selection.

I have done this in excel and its working fine there but doing same in Xcelsius- :hb:

I want to do something like in attached snapshot.
Capture2.JPG

vijesh.chandra :india: (BOB member since 2009-05-29)

#2

Arrays are not supported in Xcelsius/Dashboards. Perhaps there is a better way to achieve your end goal. What is it that you want to know ultimately from this?

~Roxanne P

RoxanneP :us: (BOB member since 2006-08-07)