3 Replies Latest reply: Feb 27, 2013 9:22 PM by Donald Hutchins RSS

    question about my expression formatting

      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?