2 Replies Latest reply on Oct 11, 2017 6:30 PM by Michael Zenn

    LOD Calculation

    Michael Zenn

      It seems like it should be simple, but I'm banging my head.

       

      I have two columns: Code and Desc

       

      Each code can have one or more Desc.  I want a count of all the codes that have more than one Desc and one of those Desc must equal RED.

       

      My LOD is

       

      IF SUM({FIXED [Code]:COUNTD([Desc])})>=2
      THEN 'Two Desc'
      ELSE 'One Desc' END

       

       

      I want to add

      AND [Desc] = 'RED'

      But I can't get it to work.

       

       

      The answer should be 5 ( Codes A,D,E,J,P)