Hi, I am struggling to find a way how to make a new calculated member.
I have fx this table :

ID___Location_____Cost___Done(Y/N)____
1 100 50 Y
2 110 120 Y
3 100 133 N
4 110 122 N

I need to know sum Done and a calculated value PR with this value :
Y/(N+Y).

How can I create a calculated value from this? I've tried a few
variations where I try to read the members in Done-field but I get
errors of loops.

SSAS2000...

Best regards,
Øyvind

What's your cube/dimension structure? If you have a measure called cost
and dimension done, then the calcualted member will be:

([Measures].[Cost], [Done].[Y])/([Measures].[Cost], [Done].[All])

"Dalen" wrote:

yongli wrote:
Great, thanks yongli, that worked perfectly.

Best regards