Hello,
I have a query with Fiscal year/Period passed as a parameter. I would like to use this parameter in a formula variable. I am trying to use an IF...THEN...ELSE structure that would look something like:
('Fiscal year/Period' < DATE(2008001)) * Selection 1 + ('Fiscal year/Period' >= DATE(2008001)) * Selection 2
However, every time I run the query, the formula returns an 'X'.
How do I set up the formula variable to do what I am trying to do?
Derrick