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 
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)
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 
(BOB member since 2010-06-23)
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)
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
Thanks for your responses
Thank you!
Sangeetha
Sakhethram (BOB member since 2012-02-08)