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)