Skip to Content
0
Nov 21, 2018 at 08:05 PM

Error while applying filter

48 Views

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

Attachments

filter-error.jpg (40.3 kB)