Proplem comparing year values in set analysis.

[#1]

I have a table with two different year entries:

LOAD

   ...

   RX,

   ...

   year(TIMESTAMP) as Year,

   ...

   Num(left('$(db_schema)',4)) as Schema_Year,

FROM

Now I want to display how many datasets exists where the Year and Schema_Year differ.

I tried

='Schema_year != year   :' & count({$< Schema_Year -= {Year}>} RX)

but that gives me the number of all records.

Thanks for your help.

[tresesco]

Try like below:

Count(If(Year<>Schema_Year, RX))  // you may or may not want to use DISTINCT

[#3]

Thanks tresesco but it does not work. The result is 0 but I know that there is one value different.

Maybe it has to do with the types?