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.
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
When should the Aggr() function NOT be used?
What is your Dimension?
=sum(qterr)/sum(qterb) should be entered as an Expression, not dimension.
Retrieving data ...