How to get even odd records in analysis of OBIEE11g
Step 1:- First we need to create an analysis report
add any extra column and click on Edit Formula
MOD(RCOUNT(1),2)
Run the report and you will get in your wishes as even or odd
Step 1:- First we need to create an analysis report
add any extra column and click on Edit Formula
MOD(RCOUNT(1),2)
Click Ok and Save The report.
Then Filter in the particular column
MOD(RCOUNT(1),2)=1
OR
MOD(RCOUNT(1),2)=2
Run the report and you will get in your wishes as even or odd
Thanks
No comments:
Post a Comment