2 Replies Latest reply on Mar 28, 2018 12:55 PM by Jim Dehner

    if then statement

    Harjeet kaur

      I have a if-then statement that gives on target if it matches  then 'on target' if not then 'below target'. however some variable are showing both statements

        • 1. Re: if then statement
          Deepak Rai

          You have rounded up values to 2 Decimal places. First Remove % and check your values in decimals and rebuild logic.

          • 2. Re: if then statement
            Jim Dehner

            Hi

            I would like to see the data and the workbook but I can think of a couple of things that would cause this - multiple records and Nulls in the data set

             

            and it is not clear it [score] is aggregated or not - suggest you aggregate Score in whatever aggregation makes sense - avg(), Min(), Max)  and wrap Score in ZN({Score])

             

            Good Luck

            Jim

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.