Calculated Member

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Walo - 02 Mar 2006 20:31 GMT

Hello All.

I am using AS 2000 and would like to create a calculated member that shows a
calculated value back to a particular month regardless of year.

Here is an example.

I am looking at data for the month of July, 2005 and I want my calculated
member to show a calculated value for the month ofo December, 2004.

I would like this to be not dependant on the year. So if I am looking at
data for July, 2004, it will calculate the member for December of 2003. The
month that I am looking for backwards from where I am is always going to be
December of the previous year.

I hope I am being clear about this.

Bill

Reply to this Message

Jéjé - 11 Mar 2006 12:40 GMT

if you have only year and month levels and if the december month is the last
month of the year this formula will return the last december:
time.currentmember.parent.prevmember.lastchild

you can create a more generic formula (using ancestor function) and there is
other way to do this job (likeusing parrallelperiod, closingperiod...).

> Hello All.
>
[quoted text clipped - 17 lines]
>
> Bill

Reply to this Message