I am trying to use Calculated Cells but am encountering errors.
Here's the descrption:
I have a Dimension hierarchy that has Members like:
Losses
Loss Paid
Current Loss


Categories
Cat Loss Paid

Now I want to add Loss Paid and Cat Loss Paid by Calculated Cells and
display the sum in Loss Paid. But whenever I create a calculated Cell
I get an #ERR.
If I create a Calculated Member then it works fine but I need
calculated Cells.

Please let me know the best way to resolve this and I donot need
Calculated Members.


Thanks

Care to post the formula?


tom @ the domain below
www.tomchester.net


"Narayan" <pnagar (AT) hotmail (DOT) com> wrote

In the MDX Builder I am adding the two members as:
[Results].&[300001001]+[Results].&[400003300]

which is Losses Paid +Cat Loss Paid

----- Tom Chester wrote: -----

Care to post the formula?


tom @ the domain below
www.tomchester.net


"Narayan" <pnagar (AT) hotmail (DOT) com> wrote

Try this:

CalculationPassValue(
([Results].&[300001001]), -1, Relative)) +
CalculationPassValue(
([Results].&[400003300]), -1, Relative))

(Syntax not checked.)

tom @ the domain below
www.tomchester.net


"PNG" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi To
This does not help as it only gives the SUM of Losses Piad (300001001) ; It does not sum up Losses Paid +Cat Loss Pai

Thank


----- Tom Chester wrote: ----

Try this

CalculationPassValue
([Results].&[300001001]), -1, Relative))
CalculationPassValue
([Results].&[400003300]), -1, Relative)

(Syntax not checked.

tom @ the domain belo
www.tomchester.ne


"PNG" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:339FC569-F559-44A5-831A-F784B59DB73C (AT) microsoft (DOT) com..

This is merely your formula wrapped inside CalculationPassValue.

tom @ the domain below
www.tomchester.net


"PNG" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi To
The problem is that the column Cat Loss Paid is actually a Calculated Cell and its calculation is also based on LOsses Paid. Therefore whenever I try this formula it gives me the value of Losses Paid ONLY and the value of CAT Losses Paid is ZERO.
Please let me know what's the cause of this

Thank

Since the value of Cat Loss Paid is also a Calculated Cell, this value
will not be finalized in the previous pass. Instead, you should be able
to use the current pass value:

CalculationPassValue(
([results].&[300001001]), -1, Relative)) +
([results].&[400003300])

However, since Cat Loss Paid is (presumably) calculated from the
original value of Losses Paid in the previous pass (otherwise, there is
infinite recursion), Cat Loss Paid must also be defined using prev. pass
for Losses Paid, ie:

CalculationPassValue(
([results].&[300001001]), -1, Relative))


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!