Variable

[Anonymous]

Hi,

I have two variables

vtwoyear=year(Today())-2

vcurrentyear=year(Today())

sum({<Environment={'$(vEnvironment)'},Dept={'$(Dept)'},Year={"<=$(vCurrentYear and >=vtwoyear) "}

>} usage) to display data for last 2 years.

but not working.

Could you please help

[Anonymous]

use this Expression:

sum({<Environment={'$(vEnvironment)'},Dept={'$(Dept)'},Year={"<=$(vCurrentYear)>=$(vtwoyear)) "}>} usage)

[settu_periasamy]

Try this

sum({<Environment={'$(=vEnvironment)'},Dept={'$(=Dept)'},Year={"<=$(=vCurrentYear)>=$(=vtwoyear)"}>}usage)

[tresesco]

Try like:

sum({<Environment={'$(vEnvironment)'},Dept={'$(Dept)'},Year={"<=$(vCurrentYear)  and >=$(vtwoyear) "}

>} usage)

[parthakk]

Hi,

U want to display for current year along with previous two years or u want it for for selected year and year-2?

[sasiparupudi1]

sum({<Environment={'$(vEnvironment)'},Dept={'$(Dept)'},Year={"<=$(=Max(Year))  >=$(=Max(Year)-2) "}>} usage)

hth

Sasi