5 Replies Latest reply: Dec 4, 2013 2:07 AM by Chanel Choo RSS

    List box with expression

      Dear Community,

       

      I want to display the list of country where the condition is media investment and revenue is greater than 0.

      I tried with 2 expressions but not working.

      Appreciate if you could help.

       

      Expressions

      1. =if([Media Investment] > 0 and Revenue > 0, Countrytarget)

      2. = if([Media Investment] > 0, if([Revenue] > 0 , Countrytarget))

       

       

      Thanks and best regards,

      Chanel