1 Reply Latest reply on Jul 5, 2012 9:25 AM by Peter Gilks

    Multiple If statements in one calculated field

    Faryal Ali

      Hi

       

      I have a field named "action". The possible values are "recommendations" , "recommendation shopping actions". If the values is recommendations shopping action, it should appear in both as it is also a recommendation action. How can I create such field?

       

      Action                                           Count

      Recommendations                           10

      Recommendations Shopping Actions  2

       

      out of these 10, 2 are shopping actions, but appear in both...Is it possible?