Dimension * Measure

[ajmcgarry]

I am trying to multiply a Dimension <DailyRateForEmp> by a Measure <Hour> in a crosstab body. All I get though is a #COMPUTATION or a #IERR.

The Measure works fine by itself and both are definately numeric.

The formula =Sum(<Hour>*<DailyRateForEmp>/8) works correctly in the Total columns to the right and bottom of the Body section but the formula =<Hour>*<DailyRateForEmp>/8 doesn't.

Any ideas?

 

[Guest_imported]

Hello ajmc garry,

Just create a new variable in the report as being &quot;=<dimension>&quot; and with &quot;Measure&quot; qualification.
Use this new variable in you formula's

 

[ajmcgarry]

cdekoning

That's not too bad but it presents another problem in that it's defeating the purpose of a measure. And by making what should be a dimension a measure causes the totals in the sum row and columns to go exponential.
It will cause it to do this

<Variable>*<Measure>*<Number of records for given dimension variable>

 

[ajmcgarry]

I solved the origonal problem by creating a hidden column containing the dimension.

Thanks anyways cdekoning.

Further input still welcome.