1 Reply Latest reply: May 23, 2017 1:22 AM by Digvijay Singh RSS

    How to insert multiple selections in an IF statement for a SUM expression?

    John Blomqvist

      Hi there,

       

      I am trying to do something like this:

       

      Field:

       

      Category: Product 1, Product 2, Product 3, Product 4, Product 5

      Year: 2012, 2013, 2014

       

      What I want to do is this:

       

      If a user selects Product 1 and Year = 2012, then Sum 1 expression

      If a user selects Product 2 and Year = 2012 then Sum 2 expression

      If a user selects Product 1, Product 2, and Product 3 and Year = 2012 then Sum 1 expression.

       

      Does anyone know how to write an If statement or a check like this?