DP macros: using fixed/locked periods in macros

[Former Member]

Hello again

I'm building a macro where one of the elements is an average of all months in 2007.

I can define this easily using something like this:

AVG(

Area: $ZCOHDP ( $ M 01.2007 ) ; $ZCOHDP ( $ M 12.2007 )

)

I was expecting the $'s to mean that everything was fixed and immobile, but it doesn't appear that way.

It turns out that the months change when we change months in the real world. I think this is because the start and end points of the area refer to a column number in the data view, and the contents of the columns move forward with time. So when we change month the macro becomes this:

Area: $ZCOHDP ( $ M 02.2007 ) ; $ZCOHDP ( $ M 01.2008 )

But as mentioned this is not what i need, i need to be able to calculate an average for 2007 that does not change every time the month changes in the real world, does anyone know if this is possible? I'd really like not having to update my macros every month.

Thanks & points in advance.

Edited by: Simon Pedersen on Oct 3, 2008 1:14 PM

Edited by: Simon Pedersen on Oct 3, 2008 1:14 PM

[Former Member · Accepted solution]

Hi Simon,

In the macro step, define the date as 'date dependent' amd specify From and To Dates.

This will make sure that it wont be on a rolling basis.

Hope this helps.

Regards,

Rajesh

[Former Member · Accepted solution]

Excellent! Thanks lot, I think that should do it.