How to conditionally display a calculated column ?

[claudialet]

  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%   ?

[NZFei]

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!

[Channa]

=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