Previous Function

[Former Member]

Hello,

I have a table in XIr 2 with the following columns

1. Group

2. Open Date

3. Id

I have put a break on Group and i want to use Previous function to get the previous open date within that group. But no matter what context i try i get the Previous open date in the first row for the preivious group

Eg

Group Open Date Id Previous

A1 12/12/2008 101

A1 12/13/2008 102 12/12/2008

A1 12/14/2008 103 12/13/2008

A2 12/15/2008 104 12/14/2008

A2 12/16/2008 105 12/15/2008

If you see the 4 the row, i want that to be blank but instead i get the pervious row's (groups) date --12/14/2008.

Is there any way to handle this? Any help is much appreciated

Thanks,

Anand

[Former Member]

Very helpful

[Former Member]

Arnand,

Try the following formula

 
= If <Open Date> != Min(<Open Date>) In (<Group>) Then Previous(<Open Date>)

You execute the Previous function on all dates within the break except the first.

Note: change the operator for 'unequal to' to the proper operator (does not show here when I try to type it in).

Rgds,

Harry

[Former Member]

Thanks Harry, Perfect, works!!!

Again many thanks

[Former Member]

null

Edited by: NR on Mar 31, 2009 3:09 PM

Edited by: NR on Mar 31, 2009 3:10 PM