BusinessObjects Board

Spreadsheet table issue

other Xcelsius - Crystal Dashboard Design
#1

Hello Experts,

I am facing an issue with Alerts, my formula is as follows

if (A1<B1,50,30) = 100 < 93 which is 30

A1 B1
100 93

10 - 35 Yellow Bubble
35 - 50 Green Bubble

I expect my bubble color to be yellow, but I am getting green bubble in my spreadsheet table :frowning:

Note : using SAP Dashboards 4.0 sp 6ā€¦ I am getting data using bi web services for my dashboards

Your help will be much appreciatedā€¦

Thank you!
Sangeetha

Sakhethram (BOB member since 2012-02-08)

#2

Not sure what is going on. I would put text boxes (temporarily) on the canvas to see what the actual values of A1, B1 and the result of the formula. Seems to be pretty odd behavior.

kevlray :us: (BOB member since 2010-06-23)

#3

Have you tried adding the formula cell to your spreadsheet table, to ensure that it is returning 30? That would be my first step, to determine whether itā€™s a problem with the formula or the alerter.

My second step would be reviewing the properties of the alerter very carefully. Especially if this your first time using them. Itā€™s very easy to do something like apply your rule to the format side and then choose to display bubbles.

Lugh (BOB member since 2009-07-16)

#4

Yes my formula result is 30 and I expect yellow when I preview my dashboard but it is greenā€¦

what I find is if I take data from web services I am having the issueā€¦

Also, I read through the below postā€¦

My scenario looks little wired :frowning:

Thanks for your responses

Thank you!
Sangeetha

Sakhethram (BOB member since 2012-02-08)