Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi here is my data set:
Name | Rate |
A | 99% |
B | 89% |
C | 34% |
D | 45% |
E | 40% |
Here is the expression:
round(Avg({1<Category={'Rate'},Dept_ID={'1'},Test_ID=P(Test_ID)>} Actual_Score)/10000,0.001)
How do I display Name with values less than 50% ?
Solution 1, do it in dimension:
Change your dimension from Name to
=if(aggr(Avg({1<Category={'Rate'},Dept_ID={'1'},Test_ID=P(Test_ID)>} Actual_Score)/10000,Name)<0.5,Name)
Then uncheck "Include null value".
Solution 2, do it in expression:
Change your expression to:
if(Avg({1<Category={'Rate'},Dept_ID={'1'},Test_ID=P(Test_ID)>} Actual_Score)/10000<0.5,Avg({1<Category={'Rate'},Dept_ID={'1'},Test_ID=P(Test_ID)>} Actual_Score)/10000,0)
Then uncheck "Include zero values" under Add-on.
Note: for solution 2, the calculation for the total line may still include the scores for all names!
=If(Aggr(round(Avg({1<Category={'Rate'},Dept_ID={'1'},Test_ID=P(Test_ID)>} Actual_Score)/10000,0.001),Name)<=0.5,Name)
try to use this in dimension