I want to display years 2002 - 1989 but combine 89 & 90. How? 2

[kevnatajax]

I have a report sorted under product, age and effective year. I have the data almost the way I want it but need to combine years 89 and 90 and display it under 90. Any suggests? Should I use a formala. I did try one formula I created but it didn't work. Here it is:

if{@efft year} =1989 and {@efft year} = 1990 then{Expected.EXEXT}

Expected.exext is the number I am trying to combine.

Thanks
Renata

 

[synapsevampire]

It sounds like you need a formula for the effective year something like:

if{@efft year} =1989 OR {@efft year} = 1990 then
1990 // Assuming that EXEXT is a number and the year
else
{Expected.EXEXT}

Now you can group, sort or sum based on this formula.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Ngolem]

I agree with SV's formula using "OR" instead of "AND"

as below:

if{@efft year} = 1989 OR {@efft year} = 1990 then
1990 // Assuming that EXEXT is a number and the year
else
{Expected.EXEXT}


However I do want to expand a bit on the comment he has made.

What is the datatype of {Expected.EXEXT}??? If it is not a number then this formula would fail. Both parts of an if statement must be of the same type.

Also the formula , {@efft year} , cannot have any reference to time evaluation functions like "WhilePrintingRecords" Jim Broadbent