alerter in cross-tab issue

building reports webintelligence
1

All,

I’m working on a cross-tab report that has the same field in the body as well as a total by Brand in the column header. I’m trying to set the alerter >= 0.95 (95%) of the total and <= 0.65 (65%).

The issue I’m running into is the variable essentially being the same. I tried setting the body of the report as [Sales] / [Total] In ([Brand];[Region]) and the Total using In([Brand]) only. I’ve tried using different functions, setting a boolean option and formuls to no avail.

Has anyone run into this before? Any tips on how to get around this would be greatly appreciated.

ngosz :us: (BOB member since 2003-09-25)

2

I figured it out. I had to do this formula in a new variable:

=[measure] / Average([measure]) In([dimension])

Then put the alerter on the new variable where the result was >= 0.95 and <= 0.65

ngosz :us: (BOB member since 2003-09-25)

3

The way I had to do it was…

I had columns of dates and rows of staff and the number of calls logged per week with an average at the bottom. I wanted to mark red on the staff below average.
My Variable for the average had to be

=Average([Number of calls]) In([Date Logged])

And my alerter was on the calls logged checking for Number of calls logged less than the new variable.

dopple :uk: (BOB member since 2009-06-19)