6 Replies Latest reply: Mar 1, 2013 7:19 AM by Jim Chadwick RSS

    difference between match and using an or statement?

      Hey guys. I have an issue that I need to solve quickly. Deadline is approaching.

       

      What is the difference between using a "match" statement, or a bunch of "or" statements? I'm switching between the two and getting different results.

       

      Here's my expression, once with "match" (the way I was using it) and once with "or" (again, the way I had used it):

       

      count( if ( Match (DSFT_SEVY_DS, 'STD', 'DCSTD') and [Medicare Type]= 'D' and DSFTT_CD = 'B' and APEL_DS = 'Denial Overturned',DSFT_ID))
      /
      count( if ( Match (DSFT_SEVY_DS, 'STD', 'DCSTD') and [Medicare Type]= 'D' and DSFTT_CD = 'B', DSFT_ID))

       

       

       

      count( if DSFT_SEVY_DS = 'STD' or  'DCSTD' and [Medicare Type]= 'D' and DSFTT_CD = 'B' and APEL_DS = 'Denial Overturned',DSFT_ID))
      /
      count( if DSFT_SEVY_DS = 'STD' or  'DCSTD' and [Medicare Type]= 'D' and DSFTT_CD = 'B', DSFT_ID))

       

       

      I seem to be getting different results. I'm not sure which to use, or if I should be going a completely different route.

       

      Please help!