2 Replies Latest reply on Sep 19, 2018 9:08 PM by meenu choudhary

    Logic Function - Need help including specifc values and excluding remaining.

    somayh.saleh.0

      Hi I am trying to create a logical function which includes specific 'Method' and 'Apple vs Orange' values.

       

      The results I want :

      1. Simple average, overall, blank,

      2. Mid, overall, apple/orange/blank

       

      What I want to exclude:

      1. Simple Average, Apple/Orange ( font red in data table)

       

      My Function:

       

      IF [Method] = "Simple Average"

      and ISNULL([Apple vs Orange])

      and [Apple vs Orange] <> "Apple"

      and [Apple vs Orange] <> "Orange"

      then "Simple Average"


      ELSE [Method]

      END

       

      My issue:

      what i want to exclude is still not being excluded. Any suggestions?

       

      Dummy Data:

      MethodStageApple vs OrangeNumberSample
      Simple AverageOverallApple5%5
      Simple AverageOverallOrange2%3
      Simple AverageOverall3%4
      MidOverallApple1%5
      MidOverallOrange2%1
      Mid4%

      6