Error of calculated dimension

[#1]

Hello

I don't understand why i have this error: "Error of calculated dimension" when i simply execute this : =sum(qterr)/sum(qterb) in a simple table.

qterr and qterb come from a SQL query.

Regards.

[swuehl]

You should not use aggregation functions in a calculated dimension without using advanced aggregation (i.e. the aggr() function). A dimension should return something 1-dimensional, not a scalar.

Dimensions and Measures

AGGR...

When should the Aggr() function NOT be used?

[Anonymous]

What is your Dimension?

=sum(qterr)/sum(qterb) should be entered as an Expression, not dimension.