Skip to Content
0
Former Member
Jan 05, 2009 at 07:48 PM

need help in writing a formula

33 Views

Hi All,

I have a BOXiR2 webi report with four variables.

1)Accno-number(type)-111111,111111,111111,111111(values)

2)Pdate-date(type)-3/9/2008,23/6/2008,1/9/2008,2/9/2008(values)

3)Claim-string(type)-234444,23456,234567,2345678(values)

4)Chknum-string(type)-666666,777777,888888,999999(values)

Now i should compare values of claim.I will compare the first value with second value of claim.i.e., 234444 with 23456.Then compare the first and second value of accno.If they are same then grab latest chknum depending on the pdate.As the latest pdate is 3/9/2008 i should get its corresponding chknum value i.e., 666666.Likewise i should compare all the values of claim.

So my final outcome will be:

Accno Chknum Pdate

1111111 666666 3/9/2008

Please help..

Thanks in Advance,