10 Replies Latest reply: Oct 10, 2015 1:32 AM by Soumya Narayanan RSS

    Conditional Expression not working

    Soumya Narayanan

      Hi,

       

      I need to implement the following logic inside a measure:

       

      If (DATE_ID >=1465 or DATE_ID <=1556) then Sum( Field1- (Field 2+Field 4)/ Sum(Field 3)

       

       

      I tried using an expression : Sum({<DATE_ID ={">=1465"}>}  {<DATE_ID ={"<=1556"}>} (Sum( Field1- (field 2+Field 4)/ Sum(Field 3)))

       

      The expression doesn't work.probably because it has multiple operators.

      Please suggest a solution.

       

      Thanks