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

    Conditional Expression not working



      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.