I’m quite confused about the following behaviour in WebIntelligence.
I have a TOP-X-Table, t.i. a table containing error data and the number of occurences of the specific errors ordered decendig by the number of occurences of a specific error. This is done by a variable using the count function, say CountErr.
The user can select how many entries he wants to see in the list. For this, i created a variable which decides via the rank-funktion, if a a row should be shown or not. This variable is used by the filter.
Furthermore i want to show the percentage of error occurences of the total of error occurences. Therefore a created another variable as
= [CountErr]/NoFilter(Sum([CountErr]) in Report))
which should do the correct calculation. But with NoFilter, it returns the wrong value, without NoFilter it works correctly, because the part NoFilter(Sum([CountErr]) in Report)) returns the wrong value, in my testcase, it should be 166 but it returns 115.
I played with the position of the NoFilter and with the optional parameters All and Drill, but nothing changes.
The interesting thing is: Even if there is no filter on the table, it returns still 115. Does anyone has an idea, whats going on here?
Thanks
martin
malthaus 
(BOB member since 2008-05-13)