Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Complex Filter Condition in BIRT
Migrateduser
<p>Hello Team,</p>
<p> </p>
<p>I created a dataset where I have two columns called BuildingClass and EventDate. I want to filter the dataset results based on below criteria.</p>
<p> </p>
<p>if (BuildingClass =='No' || BuildingClass =='' || BuildingClass ==null)</p>
<p>{</p>
<p> EventDate < (CurrentMonth +18)
18 months from now</p>
<p>}</p>
<p>else</p>
<p>{</p>
<p> EventDate < (CurrentMonth +36)
36 months from now</p>
<p>}</p>
<p> </p>
<p>Hence my dataset should be filtered based on EventDate value if BuildingClass condition is met.</p>
<p> </p>
<p>Please suggest how this can be possible. Thanks in advance!</p>
Find more posts tagged with
Comments
There are no comments yet