Skip to Content

Months between calcualted column fails when used alone in where Clasue

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)
Add comment
10|10000 characters needed 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.

  • Get RSS Feed

0 Answers