Hello,
I have a report like
Modelno Period value
2000 200304 10
200305 10
200308 10
2010 200307 20
200309 20
I want Impromptu to look wether the modelnumber is launched after periode 200307 or not. If so i want to call it "new" other "old product".
The expected values would be
Modelno Period value Kind of product
2000 200304 10 Old product
200305 10 Old product
200308 10 Old product
2010 200307 20 New product
200309 20 New product
Which If the statement should i use? Or is there another workaround? I am using Impromptu 7.1
Regards
Jules
I have a report like
Modelno Period value
2000 200304 10
200305 10
200308 10
2010 200307 20
200309 20
I want Impromptu to look wether the modelnumber is launched after periode 200307 or not. If so i want to call it "new" other "old product".
The expected values would be
Modelno Period value Kind of product
2000 200304 10 Old product
200305 10 Old product
200308 10 Old product
2010 200307 20 New product
200309 20 New product
Which If the statement should i use? Or is there another workaround? I am using Impromptu 7.1
Regards
Jules