Skip to Content
0
Feb 26, 2008 at 09:50 PM

Using Fiscal year/period in formula variable

138 Views

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