Skip to Content

Months between calcualted column fails when used alone in where Clasue

Feb 04, 2017 at 04:48 PM


avatar image

I have interesting situation. I created calculated column which returns months between as Integer. When I use it alone in where clause? it generates error. so when I use like CalMonth >=1? it works

This is how I defined calculated column

But Soon I add one partner in where clause, it works as expected. and this partner can be calmonth, calyear or any other attribute like subcategory. I AM CONFUSED why it works in that case when we add something in where class along.

6ijov.png (32.6 kB)
9guy1.png (14.8 kB)
wlrfb.png (43.8 kB)
jglwk.png (13.9 kB)
10 |10000 characters needed characters left characters exceeded

Are there any values in your full result which are not supported by the MONTHS_BETWEEN result (e.g. null values)? Maybe, due to the restriction by the additional where clause such invalid values are not taken into account.

* Please Login or Register to Answer, Follow or Comment.

0 Answers