cancel
Showing results for 
Search instead for 
Did you mean: 

Error while applying filter

developerone
Contributor
0 Kudos

Dear Community Members,

I'm seeing an error when applying filter on a specific column CALMONTH2_IN_CURRENT_QUARTER in data preview as follows:

The column that I'm trying to apply a filter on is a calculated column. It has values 'Y' and 'N', which basically tells you if the record belongs to the current quarter or not.

The calculation is as follows:

if("CALENDAR_MONTH2" >= "CURRENT_QUARTER_MNTH_FROM" AND "CALENDAR_MONTH2"<="CURRENT_QUARTER_MNTH_TO", 'Y', 'N')

CURRENT_QUARTER_MNTH_FROM and CURRENT_QUARTER_MNTH_TO are also calculated columns with the following logic respectively.

case(midstru(string(date(now())),6,2),'01','01','02','01','03','01','04','04','05','04','06','04','07','07','08','07','09','07','10','10','11','10','12','10')

and

case(midstru(string(date(now())),6,2),'01','03','02','03','03','03','04','06','05','06','06','06','07','09','08','09','09','09','10','12','11','12','12','12')

Any information on this error is highly appreciated. Please let me know if you need more information on this.

I'm working on HANA 1.0 SP12 PL6.

Thank You,
Sai

Accepted Solutions (0)

Answers (0)