error in calculated dimension

[#1]

Why do I get error in calculated dimension with this:

=if (Count(distinct NetworkSessionId) > 20, 2, if (Count(distinct NetworkSessionId) > 10, 1, 0 ) )

[pover]

You can't put any formula in a calculated dimension. The calculated dimension should be an expression that uses the aggr() function or an if() that evaluates a list of values in a field. The formula needs to return a list of values and not a simple count() or sum() that depends on some type of grouping.

Why don't you put this formula as a expression? What of chart or table do you want to create?

Regards.

[#3]

The code what you are using is not a Measure / expression ......

If you are using it in Dimesion , its ok but there is no Dimesion filed to be Populated.

for example i have dimesion Employee Name and employee Number. then we use

if( employee_Num > 20 , Employee_name)

its should have some dimension to show in that coloumn.

I hope this will work.

[#4]

PLease provide you feed back tat its woring or not !!!!!!