Can you post the aggr() code please?
The steps should be:
- create your straight table with the dimensions and the expressions (for example Dim1, Dim2 and Exp1)
- copy the expression to set in dimension (Exp1)
- create a calculated dimension with formula : aggr( Exp1, Dim1, Dim2)
- you should have in your straight table 2 columns with same value : 1 is the calculated dimension, the other is the expression.
I have given the sample code in the description , am creating variable named attendance_var and using this into expression like
attenance_var = Count(if(schoolCode=10,class_attndance))
then using the above variable in expression like
This does not shows nothing and value comes as null or -.
The Aggr() function always takes two parameters. The first is the expression you want to aggregate, the second is the dimension you want to aggregate on. In your case above, the Count() part would be fine, but you need to add the dimension on waht you want to aggregate that Count().
Hope that makes sense.