Here's the problem Description
I have 2 columns in my dimension: Losses Paid and Cat loss Paid. Cat Loss Paid is actually a calculated member and its calculation is based on Loss Paid
Now I want to calculate the value of Cat Loss Paid for the previous Month that is in Dec its hould show Nov value , In Nov it should show Oct Value and so on But when I use the following formula I do not get any value that is Zero Valu
([Results].&[400003600], [Accounting Period].PrevMember)) and even ([Results].&[400003600.PrevMember)) doenot work

Please let me know what the correct formula should be

Thanks

Cat Loss and Losses paid should be on the measures dimension. If so, all
you need to do is the following.

([Accounting Period].PrevMember, [Measures].[Loss Paid])

This will impact all levels of the accouting period. If you need to have
different logic based on different levels of the accounting period
dimension, then you'll need to wrap it in an IIF statement that tests for
the level of the Accounting Period dimesnion.

For exmaple,

IIF([Accounting Period].currentmember.level.name = "Month", ([Accounting
Period].prevmember, [Measures].[Loss Paid]), <<Your false condition here>>)


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.


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

Paid.
and so on But when I use the following formula I do not get any value that
is Zero Value