5 Replies Latest reply: Jul 12, 2012 6:10 AM by Björn Larsson RSS

    Right value when using multi box and expressions

      Hi All.

       

      I´m using a multi box and in some expressions I would like to "group" two or more fields like:

      Example: Table 1 - Car=1 if customer have car else 0.

                      Tabel 2 - Boat=1 if customer have boat else 0.

      =if(Car=1, 'Car',

         if(Boat=1, 'Boat'))

      And in multi box displayed field "Vehicle" and then Car or Boat. If you choose Car then you will have all customers that have cars(1), nothing else.

       

      This solution is not working that good. Is there some one that have any solution?

       

      Thanks in advance