date scenario solution

[ysrini9]

Hi all

mysource is OCI

posdate Ros(rateof sal)

21-01-2005 55

14-04-2005 60

08-07-2005 70

28-10-2005 75



my Target


Timpky posdate Ros


21-01-2005 21-01-2005 55

01-02-2005 21-01-2005 55

01-03-2005 21-01-2005 55

14-04-2005 14-04-2005 60

01-05-2005 14-04-2005 60

01-06-2005 14-04-2005 60

08-07-2005 08-07-2005 70



here lookup is

timpk pos

21-01-2005 55

...........................

...............................

...............................


like that now here condition is for example i am geeting datalike this : 14-01-2005 70
21-01-2005 55

here i have to tke lastest one only Ex:out of two 21-01-2005 55


finally i need to caluculate like this: 12-aug-2005 to 10-sep-2005 sales is closed in case


timpkey posdate ros

01-08-2005 08-07-2005 70*(12/31)

01-09-2005 08-07-2005 70*(20/31)

This is the scenario.

please try to help

regards
srini

[ray.wurlod]

Search the forum for techniques for remembering values from the prior row and detecting change in a column using stage variables. It can all be done with these.