7 Replies Latest reply: Jun 10, 2016 10:01 AM by Sunny Talwar RSS

    If statement where buckets may overlap

    Stuart Frew
      CUS IDCCSavCur
      1111
      2100
      3001
      4011
      5011
      6010
      7010
      8010
      9011

       

       

      Logic is something like,

      if CC = 1 then 'Cards',

      if Sav = 1 and Cur = 1, 'Marked'

       

      Please can you help with the correct IF statement for this. Some CUS ID's should end up with 2 values; ie they fall into both the Cards and Marked bucket

       

      Thanks

      Stu