This content has been marked as final. Show 3 replies
You guys see anything wrong with this? It's returning no data to display.
sum(if(APEL_LTR_SNT_DT-[Received Date] <= (if(APEL_EXTN_IN = 'N' or isNull(APEL_EXTN_IN), 30,44)) and match(DSFT_SEVY_DS, 'Standard60', '[Moved to Standard30]') and [Medicare Type]= 'C'),1))
I'm wondering if I'm doing the "isNull" wrong?
Maybe it's my entire if, where I'm returning either 30 or 44?