1 Reply Latest reply on Nov 2, 2016 3:21 PM by Stoyko Kostov

    Simplifying an LOD expression

    Matt Hong

      How would you simplify this expression?

       

      { FIXED [CaseId]: SUM(

          if [Pivot Field Names]=='Q4A A1'  then

              { FIXED [CaseId], [Pivot Field Names]: COUNT(

                  [Pivot Field Values]== "A company I'd definitely consider"

              )}

          end

      )} == 1

       

      Thank you!

        • 1. Re: Simplifying an LOD expression
          Stoyko Kostov

          If I understand correctly, you want all CaseIDs for which there is exactly one pair ([Pivot Field Names], [Pivot Field Values]) with the value ('Q4A A1', 'A company ...').

           

          Would something like this work?

           

          { FIXED [CaseId], [Pivot Field Names], [Pivot Field Values] : SUM(IIF(Name='Q4A A1' AND Value='A company ...', 1, 0)) } == 1

          ?