Conditional Whiskers?

[Anonymous]

The application is meant to show the user how Sales have behaved with relation to their respective Quotas.

In a List Box I want to include a Mini Chart that with Red-Blue whiskers - the Dimension is YearMonth - and I want a Red whisker to appear when the sales for that month were below the qouta, and a Blue whisker to appear when the sales for that month were equal or above the quota. It seems to me that an If-Else expression would do the trick, can anyone help me with the syntax and where to construct the expression?

Please see the 2 images of what I'm dealing with.

Does anyone know what I should do? Thanks for your response!

[rbecher]

Mike,

maybe it's just that easy:

=if(sales>0, 1, 0)

And then configure the minichart like this:

- Ralf

[Anonymous]

Thanks Ralf, good idea.

[rbecher]

Mike, let me know if this is working for you.

- Ralf

[Anonymous]

Thanks alot Ralf -

It's working for me now, but there was no need to me to put the IFstatement because the whiskers chart has a conditional clause built into it by definition, so I guess it was redundant. All I had to do was define my expression ; = sum(sales) - sum(quota). When that resulted in a positve number, a blue whisker appeared for the month, when negative it turned out red.

All the best,

Mike