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