3 Replies Latest reply on Sep 14, 2016 11:06 AM by Katherine Woods

    Why does my LOD expression not work when combined with an IF?

    Katherine Woods

      I am wondering if anyone can tell me why I am getting incorrect results when I combine a LOD expression within an ID statement. What I am doing looks pretty simple, and the results should be the same between the Count D calculations and the LOD expressions. However, they return different results, (see the count unique accepts columns) when combined with an IF statement. Can anyone tell me how / why this is giving incorrect results. Am I missing something fundamental???Sample deck attached.

       

      LOD question.PNG