#Computation Error for some of the rows?
I am having a scenario like this.
I am having 2 measures and 2 dimensions.
1 dimension is a rate.(which is numeric) - say it as DIM1
The two meausres are given 'Sum' as projected aggregation.
I am dispalying in atable as follows.
DIM2 Sum(measure1 * measure2 * DIM1).
But for one row I am getting "#Computation" error.
Is any one faced this kind of problem? Is there any way to get rid of this error?