on 11-21-2018 8:05 PM
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.