date scenario solution
Posted: Wed Oct 12, 2005 11:33 pm
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
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