Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to calculate the number of occurencies above or below Avg. See Example:
User | Percentage Value |
1 | 5% |
2 | 10% |
3 | 15% |
4 | 20% |
5 | 25% |
6 | 30% |
7 | 35% |
8 | 40% |
9 | 45% |
10 | 50% |
I calculate the Average Values of the Percentages easily, but how can I count the number of Users, which are above/below the Average Percentage Value.
Note: Please suggest how can I handle it in the expression directly not in the load script.
Thanks in Advance
So try this may be for Above
Count({<User = {"=[Percentage Value] > Avg(TOTAL [Percentage Value])"}>} DISTINCT User)
for Below
Count({<User = {"=[Percentage Value] < Avg(TOTAL [Percentage Value])"}>} DISTINCT User)
for Equal
Count({<User = {"=[Percentage Value] = Avg(TOTAL [Percentage Value])"}>} DISTINCT User)
What is your expression for the Percentage value?
They are pre calculated and are fixed in the qvd. So its just plane numbers.
So try this may be for Above
Count({<User = {"=[Percentage Value] > Avg(TOTAL [Percentage Value])"}>} DISTINCT User)
for Below
Count({<User = {"=[Percentage Value] < Avg(TOTAL [Percentage Value])"}>} DISTINCT User)
for Equal
Count({<User = {"=[Percentage Value] = Avg(TOTAL [Percentage Value])"}>} DISTINCT User)