Calculating Cells help 1

[Sres]

Hi,

I'm new to using OLAP and have a quick question. I've worked out how to calculate percentages using Calculated Members, however I am totally stumped on how to use Calculated Cells to divide all the measures by 100 (currency in pennys).

Any help would be appreciated

Paul

 

[MDXer]

Not really sure if Calculated Cells are what you want to use. Calculated cells are conditional calculations based upon an intersection of levles or members. If the Intersection of these produce a result of true in your condition then it applies the calculation. You are better off using Calculated members you can call a calculated member from within a calculated member

you can use something like

Calc B
[Measures].[Calc A] / 100



"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[Sres]

Thanks MDXer,

Now I look at it after what you said it does make sense

Cheers

Paul