Skip to Content
0
Former Member
Aug 30, 2007 at 08:29 AM

value of the variable FISCYEAR to compare it with a fix date

13 Views

Hi,

I'm using a hierarchy in my query. But in some case I have to multipliy the value in one column depending wich year is shown. So I tried to use a formular variable. But it doesn't work. Has somebody an idea what to do?

How can I extract the value of the variable FISCYEAR to compare it with a fix date?

Problem:

........................| Year 1 (2005) | Year 2 (2006) | Year 3 (2007)

-


hierarchy row 1 | query result 11 | query result 12 | query result 13

-


hierarchy row 2 | query result 21 | query result 22 | query result 23

-


hierarchy row 3 | query result 31 | query result 32 | query result 33 => row is hidden

-


formular row 4 | IF Year == 2005 | IF Year == 2005 | IF Year == 2005

THEN | THEN | THEN

query result 31 *10 | query result 32 *10 | query result 33 *10

ELSE |ELSE | ELSE

query result 31 | query result 32 | query result 33