2 Replies Latest reply on Feb 11, 2016 1:23 PM by pooja.gandhi

    Creating Calculated Field across Columns

    Kirby Lafferty
      Total Items
      StoreSandwichCookie
      180
      2125
      334
      4011

       

      Hello,

       

      I am attempting to create a calculated field from this filter data set. I want to separate it into 3 categories. Stores that have sales in both sandwiches and cookies, stores with only sandwich sales and stores with only cookie sales.

      I have attempted to write a line in this format:

       

      if [Item] = 'Sandwich' AND If [Value]>0 AND if Item = 'Cookie' AND if [Value]<0 THEN 'Sandwich Only'

      END

       

      but it will not work. I am not sure if this is possible in calculated fields.

       

      Thanks,

       

      Kirby