Report variable creation

building reports webintelligence
1

Hi All,
I need to create a variable at the report level in Webi Xi.

I have two variables X ,Y. X which is a variable created in the report which is Sum of Year part of a date field and some variable no of years…5,10,15,11 etc. and Y which is year part captured from a Query filter from the data provider.

Variable X is used in the report and this should get the data which is always greater that or equal to the variable Y (Year)

I tried X>=Y in the formulae with an error as Y IS AN INVALID DATA TYPE

Any work arounds please

Thanks in advance
LSS

lssreddy :uk: (BOB member since 2008-05-20)

2

What is Year, is it a character or numeric data type? If its a character convert to number and if its a number, vice versa…

Mak 1 :uk: (BOB member since 2005-01-06)

3

Both are of date format…shows as 2009 in the report!!!

lssreddy :uk: (BOB member since 2008-05-20)

4

Format them as numbers, then do your compare…

Mak 1 :uk: (BOB member since 2005-01-06)

5

Mak, thanks for the promt reply,
What is the formulae to use to format and how to do them?

Tahnks
LSS

lssreddy :uk: (BOB member since 2008-05-20)

6

Please illustrate in data what exactly you are trying to achieve :).

i.e. you are comparing Year, 2000 to what?

Mak 1 :uk: (BOB member since 2005-01-06)