What Seems to be the problem? (Where in [Year])

building reports webintelligence
1

I know this sounds odd but im having a problem with this simple formula

=[Revenue] Where([Year] = "FY2005" And [Year] = "FY2006")

and no results.

Thanks in advance :wink:

jvmauricio :philippines: (BOB member since 2009-08-03)

2

This condition fails always as you are aware of no year can be of both 2005 and 2006.

Instead you should go for something like this.

=If([Year] InList("FY2005","FY2006";[Revenue]))

Jansi :india: (BOB member since 2008-05-12)

3

I see, what I want is to show the total revenue in 2005 and 2006 but my logic seems to fail :oops:, anyway your formula worked for me, I appreciate the help :wink: thanks :smiley:

jvmauricio :philippines: (BOB member since 2009-08-03)